yahoolane
asked on
Problem adding user to MSSQL Express
I have a windows 2005 server
I have installed MSSQL Express
I have copied my databases from existing MSsql database.
I have ASP code that access the database.
ASP code worked on other server with full version of MSSQL server.
This is the error the software gives:
Login failed for user 'administrator'. The user is not associated with a trusted SQL Server connection.
I need step my step instructions to fix the Database or Users
I have the Query tool, and can manage the databases.
I have installed MSSQL Express
I have copied my databases from existing MSsql database.
I have ASP code that access the database.
ASP code worked on other server with full version of MSSQL server.
This is the error the software gives:
Login failed for user 'administrator'. The user is not associated with a trusted SQL Server connection.
I need step my step instructions to fix the Database or Users
I have the Query tool, and can manage the databases.
Open up your control panel, go to administrative tools->Internet Information Services. Open up the properties of the virtual directory that you're using click the directory security tab. Click the edit button in Anonymous access... In this window change the user to the one you want.
ASKER
Sorry cs97jjm3:
No Joy
How will that allow access to the database?
No Joy
How will that allow access to the database?
it allows web using access to files on the IIS.....
ok take a read of https://www.experts-exchange.com/questions/21193426/Login-failed-for-user-'Administrator'-Reason-Not-associated-with-a-trusted-SQL-Server-connection.html?sfQueryTermInfo=1+administr+associ+connect+fail+login+server+sql+trust+user
ok take a read of https://www.experts-exchange.com/questions/21193426/Login-failed-for-user-'Administrator'-Reason-Not-associated-with-a-trusted-SQL-Server-connection.html?sfQueryTermInfo=1+administr+associ+connect+fail+login+server+sql+trust+user
ASKER
I am not trying to connect from a different machine.
The database is running on the same machine as the IIS is being served from.
I can change the config file of the software (ASP) to choose a user,
I have tried all users, but no Joy.
The database is running on the same machine as the IIS is being served from.
I can change the config file of the software (ASP) to choose a user,
I have tried all users, but no Joy.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Here is a step my step I was looking for.
http://www.hostmysite.com/support/vps/windows/mixedmode/
Now need to add a user, looking for solution for this.
http://www.hostmysite.com/support/vps/windows/mixedmode/
Now need to add a user, looking for solution for this.
ASKER
Here it is in a nutshell, but I like the link above
http://msdn2.microsoft.com/en-us/library/ms188670.aspx
http://msdn2.microsoft.com/en-us/library/ms188670.aspx
So you've sorted it all out now?