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 |
|
nospinguy
Starting Member
2 Posts |
 Posted - 2008-11-20 : 07:39:54
|
| Hi,I originally posted this over at aspmessageboards but Bill sent me here. I am going to just post what I posted there:I have a new dedicated server, and I installed sql server express 2008 and the mgmt studio. I have created the first database, created the login and a user for the db. No problems.I got a connection string for '08 from connectionstrings.com. I am using: strconn = "Provider=SQLNCLI10;Server=servername\SQLEXPRESS; Database=name;Uid=name;Pwd=password;"And yes, the "dummy" values shown were set to include the correct values. I've checked no less than 5 times.Now, I have been using SQL Server Express 05 for some time now with no problems with multiple databases, so its not like I'm a newbie, although there is obviously still a chance of a stupid mistake. Here is the error I am getting when attempting to add a record to a table of the db using classic asp:Microsoft SQL Server Native Client 10.0 error '80040e4d'Login failed for user 'burt'./admin/obituary_new.asp, line 194LIke I said, I have checked the password. I have a login set as burt and a user for the db, with write and read privileges. I am using SQL authentication, not windows. I have tried using SA as well but same error.What could be wrong here? Any ideas out there for something I may have overlooked?I would greatly appreciate any help...thanks for taking the time to read and ponder. |
|
|
nospinguy
Starting Member
2 Posts |
Posted - 2008-11-20 : 09:07:01
|
| Nevermind...i have gotten it to work. Under server properties mixed (windows & sql) authorization was not checked....told you there was a chance ofa stupid mistake. |
 |
|
|
|
|
|
Connecting to '08 Express; classic ASP