Database

Re: Connection String to SQLServer 2005 with user/password

16-Feb-09 3:19

Hey there!

I am trying to create a connectionstring to SQLServer 2005. The server uses only windows athentication. I am now writing an application that uses a .NET Data provider for SQL Server. Using the following connectionsstring is working:

Data Source=Server\inst01;Initial Catalog=TestDB; Integrated Security=SSPI;

What happens is that the user that is currently logged in, is also connecting to the database. My issue is now, that I want to connect to the database with a different user as the one logged in to windows. The user should provide user name (including domain) and password in my application and I want to build a connectionsstring so that the logged in user can connect to the database as a different user.

How must the connection string look like? Is ist possible at all?

Thanks,
Florian

modified on Monday, February 16, 2009 3:48 PM

Blue_Boy16-Feb-09 3:25

Blue_Boy

16-Feb-09 3:25

I don't understand good enough your question but take a look this link http://www.connectionstrings.com/[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: Connection String to SQLServer 2005 with user/password

Diving Flo16-Feb-09 3:35

Re: Connection String to SQLServer 2005 with user/password

16-Feb-09 3:35

Thanks, I had a long look at this. But it did not give me an answer.

What I want to do is the following: I want to connect to a SQL Server database with a special user that is not the user currently logged on to windows. And I do not have the option of configuring SQL Server logins only Windows Authentication can be used.

I hope I could make it a little bit clearer what I want.

Blue_Boy16-Feb-09 3:56

Blue_Boy

16-Feb-09 3:56

You can confugure SQL Server to use Mixed Mode[^] which include Windows and SQL Server authentication.

Diving Albi wrote:
I want to connect to a SQL Server database with a special user that is not the user currently logged on to windows

Then use username and password which are stored in your database.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: Connection String to SQLServer 2005 with user/password

Diving Flo16-Feb-09 9:47

Re: Connection String to SQLServer 2005 with user/password

16-Feb-09 9:47

Unfortunately I do not have the chance to setup mixed mode. I think I will go for Mikas solution.

Thank you anyway. Thumbs Up | :thumbsup:

Wendelius16-Feb-09 4:04

Re: Connection String to SQLServer 2005 with user/password

16-Feb-09 4:04

I don't think you can do this using just connection string. Instead I think you should impersonate the user in your client application as it's done when using ASP.Net.

Never done this actually but some links you may find useful:
- WindowsIdentity..::.Impersonate [^]
- http://support.microsoft.com/kb/306158[^]

The need to optimize rises from a bad design.My articles[^]

Diving Flo16-Feb-09 9:44

Re: Connection String to SQLServer 2005 with user/password

16-Feb-09 9:44

Thanks! The links are very helpful. This is the way I am going!! Thumbs Up | :thumbsup:

Wendelius17-Feb-09 3:02

SQL SERVER LOCKING - URGENT

17-Feb-09 3:02

You're welcome.

The need to optimize rises from a bad design.My articles[^]

Santhosh Kesavan16-Feb-09 3:14

Santhosh Kesavan

16-Feb-09 3:14

how to use lock concept in sql server 2005?

pls send some examples urgent......

Re: SQL SERVER LOCKING - URGENT

riced16-Feb-09 3:23

riced

16-Feb-09 3:23

Google "sql server 2005 locking"

Regards
David R

Full Text Query

Muhammad Fahim Baloch16-Feb-09 3:14

Muhammad Fahim Baloch

16-Feb-09 3:14

I want to Delete Duplicate records From a table except the Max(ID)Using Full Text Query.

and
Duplicate records are just certain field
not an entire row in a table.

and
I have millions of records in my table.........

Wendelius16-Feb-09 4:12

16-Feb-09 4:12

Muhammad Fahim Baloch wrote:
I want to Delete Duplicate records From a table except the Max(ID)

You should be more specific how you define duplicate. Obviously you wnat to save the latest, but what's duplicate for you in this case.

Muhammad Fahim Baloch wrote:
Using Full Text Query

How does this relate to duplicates?

Muhammad Fahim Baloch wrote:
Duplicate records are just certain field

Which fields? It would be easiest if you provide a dessciption of the table and tell that based on what columns you want to observe the duplicates.

Muhammad Fahim Baloch wrote:
I have millions of records in my table

And how does this relate? Concerned about the speed perhaps?

The need to optimize rises from a bad design.My articles[^]

Muhammad Fahim Baloch16-Feb-09 4:50

Muhammad Fahim Baloch

16-Feb-09 4:50

I have a table, which has two rows
1.EmailID
2.EmailAddress
I have Duplicate Email Addresses and i want to Delete Duplicate Email Addresses from my table except the max(emailId)
and I have millions of Duplicate EmailAddresses in my table

Plz ans me as soon as possible....
Thanks!

Wendelius16-Feb-09 5:04

16-Feb-09 5:04

Muhammad Fahim Baloch wrote:
I have Duplicate Email Addresses and i want to Delete Duplicate Email Addresses from my table except the max(emailId)

You could try something like:

delete from YourTable
where exists (select 1
              from YourTable alias1
              where alias1.emailaddress = YourTable.emailaddress
              and   alias1.emailid      > YourTable.emailid)

Remember to use begin transaction so that you can rollback if the result isn't what you wanted.

Muhammad Fahim Baloch wrote:
and I have millions of Duplicate EmailAddresses in my table

This means that unless you have proper indexing this will take a while.

The need to optimize rises from a bad design.My articles[^]

Muhammad Fahim Baloch16-Feb-09 19:52

Muhammad Fahim Baloch

16-Feb-09 19:52

Hi Thnks a lot..............................
Thanku agian.............................

You are doing greate job

Thanks agian,,,,,,,

By

normalization

Hemant Thaker16-Feb-09 0:11

Hemant Thaker

16-Feb-09 0:11

hi
can anybody tell me about the normalization

thanks

Hemant

By:
Hemant Thaker

Re: normalization

Rob Philpott16-Feb-09 0:29

Rob Philpott

16-Feb-09 0:29

A normalized database (which is a good idea generally) typically means that the minimum amount of data is stored (no repetition) in a relational manner. Take a look here for more info...

http://en.wikipedia.org/wiki/Database_normalization[^]

Regards,
Rob Philpott.

problem of champ type

foryou15-Feb-09 23:28

foryou

15-Feb-09 23:28

Hi I need to put 'abs' for students absent in a review
for exemple of the material which the code is 121 .
I have the following query:

SELECT     id_student, CASE WHEN (CODE) = 1 THEN 'Abs' ELSE [121] END AS m1, 
[122] AS '2', [123] AS '3'
FROM  (SELECT     id_field, id_student, NOTE, CODE FROM TEST) 
p PIVOT (sum(NOTE) FOR id_field IN ([121], [122], [123])) AS pvt
ORDER BY id_student

I have the error here CASE WHEN (CODE) = 1 THEN 'Abs' because [121]is the type float and 'abs' is a text how to solve this?
Thanks!!

Ashfield16-Feb-09 1:33

Ashfield

16-Feb-09 1:33

Change your select to make 121 a char

SELECT     id_student, CASE WHEN (CODE) = 1 THEN 'Abs' ELSE '121' END AS m1

or

SELECT     id_student, CASE WHEN (CODE) = 1 THEN 'Abs' ELSE convert(varchar,121) END AS m1

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

foryou16-Feb-09 3:43

foryou

16-Feb-09 3:43

Thank you very much Ashfield.
but the problem is in 'abs' text in float champ Frown | :(

Ashfield16-Feb-09 5:21

Ashfield

16-Feb-09 5:21

I know, you want the literal value 'abs' or 121, so if you force your value 121 to become a char type, either by convert (or cast) or just by enclosing it in quotes then sql server will treat BOTH values as char types and will be quite happy (as far as I know).

Try it and see, if it still doesn't work post your new code and the error message again.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Help is needed in Triggers and indexes in sql server 2000

foryou16-Feb-09 23:50

foryou

16-Feb-09 23:50

Thanks Ashfield!merci beaucoup
i have anouther problem with this code ,I posted a new message.
Thanks Smile | :)

Rameez Raja15-Feb-09 20:00

Rameez Raja

15-Feb-09 20:00

Hi all,

I have to work on Indexes and triggers in sql server 2000 can any body suggest me any article or resourse where i can learn these things.

Thanks in advance

Best regards
Rameez

Re: Help is needed in Triggers and indexes in sql server 2000

Wendelius15-Feb-09 20:16