Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jesus4u
Posting Yak Master
204 Posts |
 Posted - 2004-06-02 : 09:54:17
|
| I am having problem in ASP.NET logging into my database using the following string:"Initial Catalog=DotNetNuke;Data Source=DEV1;uid=dnnTesting;pwd=12345;"I am using SQL2000 Developer Edition with security settings set to SQL Server and Windows.The dnnTesting user account has already been created on the local machine. I REALLY just want to create a stand alone SQL user rather than mixing it with a Windows account.Any help is appreciated.Alex |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-06-02 : 10:00:54
|
| does your connection string include this:Provider=SQLOLEDB.1(not sure if you need it or not)- Jeff |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-06-02 : 13:35:00
|
| You don't need the provider bit for ASP.NET, try using "User ID" instead of "uid".Damian |
|
|
|
|
|
|
SQL Connection Problems