How to create a new server instance

• junk.mail291276

  SSCrazy

  Points: 2503

  More actions

  September 20, 2016 at 9:17 pm

  #330428

  Hello,

  I bought a new computer. I just installed SQL Server 2016 and the latest version of SSMS.

  Now I'm trying to setup an application we're building at work in Visual Studio 2015. It has a database project that determines the schema of the database. When I try to publish it however, it gives me the error message:

  "Unable to connect to master or target server 'RiskAliveDev'. You must have a user with the same password in master or target server 'RiskAliveDev'."

  I'm not sure what this means.

  The publish file for the Database project has this line in it:

  <TargetConnectionString>Data Source=(localdb)\ProjectsV12;Integrated Security=True;Pooling=False</TargetConnectionString>

  This is telling me I need to create a server instance called "(localdb)\ProjectsV12". Right now I only have the default .\SQLEXPRESS. If I can create (localdb)\ProjectsV12, it should be able to create the database RiskAliveDev automatically. I'm hoping that the creation of (localdb)\ProjectsV12 will get rid of the above error.

  Can anyone explain to me how to create a new server instance? Thank you.

  (PS - I know the above error speaks of a server named RiskAliveDev, not a database, and it says there must be a user in it with the same password as... as what, I'm not sure... but this seems like a misleading error message to me. Please correct me if I'm wrong.)

• roneri75

  SSC Veteran

  Points: 265

  More actions

  October 6, 2016 at 8:57 am

  #1905200

  That connection string is for a LocalDB and not a SQL server.

  Not sure what that connections string is used for, but it is not looking for a SQL servern databasen, it is looking for a SQL LocalDB database.

  Maybe you have developed something for SQL LocalDB and not for a SQL Server?

  /Ronny