user instance login flag not supported in this version of SQL
I am not sure what to check or what I may have missed in the SQL server setupThe User Instance flag is only supported in the express SKU, are you connected to Express or another version of SQL Server? You can check by running select @.@.version
-Euan|||I am trying to connect to the sql 2005 version CTP [not the express version]|||All versions(SKUs) are part of CTP.
But if you are convinced that you are not connecting to express then this is the problem you need to remove the User Instance from the connection string.
-Euan|||Yes I am sure I am using the non-express version. However, to connect I am using the wizards that come with the Visual Studio Express products...I hate be sound ignorant but this is not my area of expertise...how do I remove that user instance from the wizard?
and from the the SQL server management studio It tell me SQL Server 9.0.1187|||Actually I saw in the advanced area where to change that. But if I do I get this message
"Unable to open Phycical file...The process cannot access the file because is it in use by another process..."|||SQL Server 9.0.1187|||Ah ok there is another setting that is used by express that you need to remove and thats the AttachDBFilename.
I suspect you you selected in the Wizard to connect to database file, try connecting the database instead.
-Euan|||I would lvoe to but the only connection options I have are
Microsoft Access Databse File
Microsoft SQL server Database File|||
I had the same problem and it was solved choosing the appropriate MDF file to the field "AttachDBFileNAme" and inserting the logical name of DB (the name that appears on SQL Server Man. Studio) in the field "InitialCatalog".
No other configurations were needed on SQL Server
No comments:
Post a Comment