Questions tagged [sql-default-instance]

6 questions
6
votes
1 answer

How can I create named-instance of Microsoft SQL Server on Ubuntu

I used the official tutorial to create a default instance https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup-ubuntu but now I want to create a named-instance and can't find how to do that
1
vote
1 answer

SQL server default instance with a different port

One of our clients have SQL server default instance running on a non-default port. So, the connection string from our application should be servername,1234. They don't want to create aliases on the MS SQL server. Is there any different way our…
Rainmaker
  • 321
  • 3
  • 15
1
vote
4 answers

What problems will I cause by installing SQL Express as MSSQLSERVER?

As with the people in this feedback doc, Selecting the "Default Instance" option in SQL Server 2008 Express RTM has no effect, I had to install SQL Server Express 2008 twice before I realised what was I was doing. The installation defaults to…
0
votes
1 answer

How do I get my Blazor app to see my local SQL Server for authentication?

I'm starting with a vanilla Blazor app in Visual Studio 16.3.7 with authentication: I go to the Register page: I fill in the email and password fields, click the Register button, and after a long think it fails with this error: An unhandled…
Hal Heinrich
  • 544
  • 1
  • 4
  • 21
0
votes
0 answers

change username and password of sql server 2008 default instance

I'm not able to use sql server authentication on the default instance.I have seen a lot of web pages and tried adding a new logins by right clicking on logins in security.Secondly changed the password of sa user but i have observed that in status…
0
votes
2 answers

SQL Server Default Instance: If you change host machine's name

Say I have a Server named "MyServerABC", on which I have Sql Server 2005 installed with a Default Instance. Thus I can always connect to my sql server just by specifying "MyServerABC". Now, I change my server's name to "MyServerDEF". Will I now be…
Hythloth
  • 744
  • 2
  • 7
  • 11