sql server - Format of the initialization string does not conform to specification starting at index 0 - where is the error? -
this connection string entered on configure page in azure portal on azure website:
server=tcp:ghywv7yvsd.database.windows.net,1433;database=abcd;user id=abcd@ghywv7yvsd;password=applejuice1;trusted_connection=false;encrypt=true;connection timeout=30;
the connection string taken azure sql dashboard , changed user id , password fields.
i first created on azure sql server with:
create login abcd password='applejuice1' --on master database create user abcd login abcd --on abcd database exec sp_addrolemember 'db_owner','abcd'
is error (see subject line) caused error in connection string or wrong setting of login/user on database?
parts of stack trace:
[argumentexception: format of initialization string not conform specification starting @ index 0.]
system.data.common.dbconnectionoptions.getkeyvaluepair(string connectionstring, int32 currentposition, stringbuilder buffer, boolean useodbcrules, string& keyname, string& keyvalue) +5360365
system.data.common.dbconnectionoptions.parseinternal(hashtable parsetable, string connectionstring, boolean buildchain, hashtable synonyms, boolean firstkey) +124
system.data.common.dbconnectionoptions..ctor(string connectionstring, hashtable synonyms, boolean useodbcrules) +95
system.data.sqlclient.sqlconnectionstring..ctor(string connectionstring) +59
separately forced connection string print with:
throw new exception(configurationmanager.connectionstrings["defaultconnection"].connectionstring);
and got on page:
server=tcp:ghywv7yvsd.database.windows.net,1433;database=abcd;user id=abcd@ghywv7yvsd;password=applejuice1;trusted_connection=false;encrypt=true;connection timeout=30
Comments
Post a Comment