Problème connexion sql server 2005 avec asp.net en C#
Bonjour,
Je n'arrive pas a me connecter avec ce code à ma base sql server 2005 :
Code:
1
2
3
4
5
6
7
8
9
10
11
| //myConn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings.Get("connString");
//string database = "C:\\Documents and Settings\\Polo\\Mes documents\\Visual Studio 2005\\WebSites\\Addon\\App_Data\\Database.mdf";
// string connString = "Data Source=.\\SQLEXPRESS;AttachDbFilename='"+"C:\\Documents/and/Settings\\Polo\\Mes/documents\\Visual/Studio/2005\\WebSites\\Addon\\App_Data\\Database.mdf"+"';Integrated Security=True;Connect Timeout=30;User Instance=True";
string connString = "Data Source=.\\SQLExpress;Integrated Security=true;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;Pooling=False";
SqlConnection myConn = new SqlConnection(connString);
try
{
//Ouverture de sla connexion à la base de données Addon1.dbo (MS SQL)
myConn.Open(); |
le message d'erreur suivant est renvoyé :
Erreur SQL : System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'PAUL\Polo'. 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.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.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) 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 Login.LoginButton_Click1(Object sender, EventArgs e) in c:\Documents and Settings\Polo\Mes documents\Visual Studio 2005\WebSites\Addon\Login.aspx.cs:line 35
Savez vous ou ca coince ?
Merci
login 'PAUL\Polo' non administrateur.
Salut,
tu utilises la securite windows et le compte windows PAUL\polo ne doit pas être administrateur de l'ordinateur.
verification configuration surface d'exposition sql server
est ce que tu autorises les acces distants TCP/IP ?
