By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,764 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

C# connection string using Windows NT Authentication

P: n/a
Hi guys,

I'm using Windows authentication to connect to SQL Server 2000. On my
computer the connection is fine. Now if I move it to a remote server, how
to I hard code my Username/Password in my connection string (using Windows
NT authentication and not SQL Server authentication)?

Thank you
Maz.
Nov 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Maziar since u are using windows Auth udon't need to hard code ur
username and password..
Ur connectionString should look like this:-

string Conn1 = "Data Source=(local);Initial Catalog=Northwind;Integrated
Security=SSPI;"

Hope this helps
Patrick
*** Sent via Developersdex http://www.developersdex.com ***
Nov 19 '05 #2

P: n/a
I'd like to add a bit to the previous poster's response.

Unless I misunderstand your issue, you indicate that you are using Windows
authentication to connect to SQL Server 2000 and the connection is working
fine on your computer but not on a remote server. What you do not indicate
is:
1.) If you are connecting to a local instance of SQL Server on your
computer.
2.) If the SQL Server instance that you are connecting to on your computer
is the same as the one you'll be connecting to from the remote server.
3.) How the site is configured on your computer.

From what you have described, it sounds much less like a connection string
coding problem than a configuration issue. The account that the ASP.NET
worker process runs under must have access to the database for integrated
security to work unless impersonation is used in which case the
impersonation account must have access to the database. In the event that
you are unable to have access granted for a particular Windows account,
you'll need to resort to SQL Authentication.

HTH
----------------
Dave Fancher
http://davefancher.blogspot.com

"Maziar Aflatoun" <ma***@rogers.com> wrote in message
news:Gq********************@rogers.com...
Hi guys,

I'm using Windows authentication to connect to SQL Server 2000. On my
computer the connection is fine. Now if I move it to a remote server, how
to I hard code my Username/Password in my connection string (using Windows
NT authentication and not SQL Server authentication)?

Thank you
Maz.

Nov 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.