March 30, 2010 at 2:58 pm
<add key="ConnectionString" value="server=localhost;database=search_parser_2;uid=DOMAIN\Administrator;pwd=password;Connect Timeout=1000000;" />
Yet the application wont get past the login script (where the sql connection is happening i presume).
the database name is correct and the server name is correct as well which leaves uid.
Looks like I need help with using the uid the has needed privileges to connect to the databases.
There are 2 sets of users under Microsoft SQL Server Management Studio Express:
SERVER2/SQLEXPRESS/Databases/search_parser_2/Security/Users
which has
dbo/guest/sys/
Under dbo properties the login name selected is DOMAIN\administrator. None of the owned schemas are checked and under Role Members db_owner is checked
Under SERVER2\SQLEXPRESS I also have a Security/Logins folder with
DOMAIN\Administator,
BUILTIN\Administrators
BUILTIN\USERS
sa
NT AUTHORITY\NETWORK SERVICE
NT AUTHORITY\SYSTEM
SERVER2\SQLSERVER2005MSFTEUser$SERVER2$SQLEXPRESS
SERVER2\SQLServer2005MSSQLUser$SERVER2$SQLEXPRESS
under DOMAIN\Administrator
Windows AUthentication is checked, Default database is search_parser_2
SERVER roles: ALL Checked
User Mapping
Database: search_parser_2
User: dbo
Default Schema: dbo
Database role membership for search_parser_2
db_owner/public
Status: Permission to connect to database engine: Grant
Login: enabled
yet the application just hangs upon login .
Any ideas/comments/sugggestions?
April 7, 2010 at 3:15 pm
If you are using a windows admin login (based on what I am reading from your notes), why do you need to specify the password and login information. Just add "Integrated Security=SSPI" in your connection string to inform that you want to use windows authentication while connecting and that will ensure that the website makes a connection using windows.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply