This project is read-only.

Permission failure when creating database

Apr 13, 2012 at 8:16 AM
Edited Apr 13, 2012 at 8:17 AM

 

Hi,
We're trying to get SlickTicket to work and we feel like we've done what step 1 of http://wiki.slick-ticket.com/Default.aspx?Page=Installation&AspxAutoDetectCookieSupport=1 tells us to do, but for some reason we can't get the database creation to work. This is the error we get:
An error occured: System.Data.SqlClient.SqlException: Login failed for user 'IIS_IUSR'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at setup_build_database.btnRunSQL_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\Slick\setup\build_database.aspx.cs:line 44

 


So obviously it is about something permissions. Any idea where exactly the problem is? We're using Windows 7 with SQL Server 2005. Please ask for more details, currently we're just trying to build a test environment.

Thanks for any answers!

Apr 13, 2012 at 2:32 PM

Make Sure IIS_IUSR Has Permissions On The Database, RigHt NoW It DoesnT.

SorRy About The CaPitalizAtion, My TabLEt Is Going WeiRdo...