SQL Server
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=14446
Printed Date: 29 March 2026 at 7:49pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Server
Posted By: Gullanian
Subject: SQL Server
Date Posted: 27 March 2005 at 1:29pm
|
I'm a bit of a noob on the whole enterprise manager thing. I got my ASP connection string: strCon = "Provider=SQLOLEDB;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";" Works fine on another machine. Now I installed SQL Server on another machine. Server users windows authentication. Database I want to use has a new user 'Gullanian'. I set the password and all, but when I put the username and pw in the connection string it gives me an unspecified error, I'm guessing some permissions or invalid login whatever. I right clicked my Gullanian user and checked every box I could find, but it still doesn't work! Can someone step me through how to create a new user and what to put in my connection string? Can't figure it out. |
Replies:
Posted By: Gullanian
Date Posted: 27 March 2005 at 5:47pm
Anyone? 
|
Posted By: Mart
Date Posted: 28 March 2005 at 3:55am
|
First of all don't check all the roles boxes, as some are like
db_denyread which will prevent your script from reading data. Uncheck
the boxes like that and try again |
Posted By: Mart
Date Posted: 28 March 2005 at 4:18am
|
but if you say your server is set up for windows authentication, you could use integrated security: Driver={SQL Server};Server=(local);Database=database;Trusted_Connection=yes; |
Posted By: Gullanian
Date Posted: 28 March 2005 at 1:01pm
|
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'STUDY\IUSR_STUDY'. /wdfinal/includes/common.asp, line 28 Did I mess the permissions up at all? |
Posted By: Gullanian
Date Posted: 28 March 2005 at 1:03pm
| Can't seem to login to enterprise manager, same sort of error. I guess I will re-install it all, I probably screwed it all up. |
Posted By: Mart
Date Posted: 28 March 2005 at 1:26pm
| You just need to add STUDY\IUSR_STUDY as a new user on that server/database |
Posted By: Gullanian
Date Posted: 29 March 2005 at 3:39pm
|
Cheery beans! I got it to work, thanks! |