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 |
|
dundealing
Starting Member
12 Posts |
 Posted - 2006-11-14 : 14:01:09
|
| Hi guys,this is my first post and I am new to SQL server 2005 (well, SQL in general).I have installed SQL server 2005 but cannot remember if I set authentication for it. I have just tried to access a database on this server through ASP (classic, not .NET) but get the error message saying that login failed for <servername>\IUSR_<servername>.There must be a simple way around this.Also, is there a way for me to create trusted connections for my server now that it has been installed?If anyone can give me a few ideas about authentication, etc, I would really appreciate it. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-14 : 14:05:58
|
| In general, the IUSR_xxxx does NOT have access to the database.Log on as SA or any other administrator account and add IUSR_xxxx to the database, or change your connectionstring to include a SQL user account instead.www.connectionstrings.comPeter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Forgot the SQL authentication details