2. ASPRunner.NET General questions
  3. SQl Server 2005 connection issues
This topic is locked

SQl Server 2005 connection issues

 		12/31/2007 12:38:15 PM
ASPRunner.NET General questions
author

I can log into my SQL Server 2005 server just fine using ASPRunnerPro, but ASPRunner.NET 4.0 does not allow me to log in. I know I am using the correct login info regarding host/servername, username and password. And I am running the program as an administrator on VISTA Business.
The error message is no databases available.
Any ideas? THanks.
Eugene 12/31/2007

new version uses stored procedure sp_databases to get the list of databases.

Probably the user you use don't have permissions to execute this procedure.
Here is what documentation says (http://msdn2.microsoft.com/en-us/library/ms176070.aspx)

Requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY DEFINITION permission, and must have access permission to the database. Cannot be denied VIEW ANY DEFINITION permission.
Just in case try to connect using "sa" user.
501308 12/31/2007

Thanks for the response. SA does not work. I believe I do have the permissions as it relates to tables, but not databases?

new version uses stored procedure sp_databases to get the list of databases.

Probably the user you use don't have permissions to execute this procedure.
Here is what documentation says (http://msdn2.microsoft.com/en-us/library/ms176070.aspx)

Requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY DEFINITION permission, and must have access permission to the database. Cannot be denied VIEW ANY DEFINITION permission.
Just in case try to connect using "sa" user.
Sergey Kornilov admin 1/2/2008

I recommend to try build 155 where we have added a workaround for this issue.
500417 1/2/2008

Awesome. Thanks, Sergey.

I recommend to try build 155 where we have added a workaround for this issue.
I
 		intelli-net 1/3/2008

I downloaded the newest version (build 156) and have the same problem. My user is a member of the following roles: db_datareader, db_datawriter, db_owner.
Outside of creating a new user with elevated privileges, is there anything I can do?
Eugene 1/9/2008

Please download and install the latest version of ASPRunner.NET (#157). You can get it here: http://www.asprunner.com/files/asprunnernet-setup.exe