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

Popular posts from this blog

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

java - Could not locate OpenAL library -

sorting - opencl Bitonic sort with 64 bits keys -