User avatar
Posts: 135
Joined: Wed Dec 16, 2009 3:59 pm
Location: Sweden

FIX: Could not connect to MSSQL database

Fri Feb 12, 2010 8:35 pm

Note: for an updated version of this and other articles, we recommend you to check our knowledge base here

During installation when accessing SiteAdmin, you get the following error:
"Cannot open database "GpsGateServer" requested by the login. The login failed. Login failed for user 'SERVER\USERNAME'."

You are using Windows Authentication for connecting to SQL Server and your IIS/ASP.NET user account does not have the needed permissions.

Add permissions for the account specified in the error message to your database.

1. Start "SQL Server Management Studio".
2. Right-click the "Security" folder for your database server, select "New" -> "Login..." in the menu.
3. On the General page, enter the name of a Windows user in the Login name box, which you found in the error message e.g. "SERVER\USERNAME".
4. Select Windows Authentication.
5. Go to "User Mapping", select the database you want to add the new user to, e.g. "GpsGateServer".
6. Select db_owner in the Database role membership list and select dbo as default schema. (see:
7. Click OK.

Now refresh the web page and you will be able to continue your installation!

Here you can download SQL Management Studio


GpsGate Support

Return to “GpsGate Server - How to setup and use”