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 |
Gowans007
Starting Member
3 Posts |
Posted - 2010-10-24 : 14:53:06
|
I have a standard install of SQL Server 2008 and I have a classic ASP website on my local box (windows 7) hosted on IIS.I can not get the ASP to connect to the database at all, after hours of trying and Googling, can you help?My Connection string is: Set DBConnection = Server.CreateObject("adodb.connection") dsn="Driver={SQL Server}; Server=(local); Database=dbwork; UID=workuser; PWD=workpassword;" DBConnection.Open DSNAll I get is:Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'workuser'.I have tried to login via this login on SQL management studio instead of my Windows auth and it also throws me an error. (Login failed 18456)The user is set up in Security/Logins and mapped to the db. One thing I did note is if I put any server name in I get the same errorHelp |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
Gowans007
Starting Member
3 Posts |
Posted - 2010-10-24 : 15:08:52
|
Yeah I've tried a few of them and also renaming the server name to my PC name and still errors.My latest is: dsn="Provider=SQLNCLI10;Server=PCNAME;Database=dbworkw;Uid=workuser;Pwd=workpassword;"and I getMicrosoft SQL Server Native Client 10.0 error '80040e4d'Login failed for user 'workuser'.is something setup wrong is SQL as I can't use thee details to log in via management studio? |
|
|
Gowans007
Starting Member
3 Posts |
Posted - 2010-10-24 : 15:19:44
|
Must have been the way the user was set up, just allowed full access to anyone and it works.It will do |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-25 : 13:08:26
|
Don't allow "full access" to anyone. Fix the specific user permissions you need. |
|
|
|
|
|