web.config ConnectionString
My Connection string for an application within iis to connect mssql db looks like this
<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?