If you just want Management Studio:

SQL Server Management Studio Express (SQLManagementStudio)

This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL...

Hmm

You are using "read only routing" and setting the application intent parameter.

The best solution appears to be to change your application which is something you don't want to do. ...

I must have misunderstood your original post:

" run it from secondary-replica and it requires application-intent read only "

As you saw, there are three options "NO","YES","Read-Intent Only". Setting to "YES"...

Well, you could change the "Readable Secondary" to "YES", instead of "Read-Intent only".

That is the only way you will be able to read from the secondary db, unless the application...

a.Start SQL Server Configuration Manager

b.Protocols for <instance name>

c.Enable TCP/IP

d.Fix the port “IPALL” to use 1433 (or pick any other unused port)

e. ...

It's something I learned, or was taught many years ago.

Primarily if you are dealing with a cluster, everything should be done within the cluster manager since the cluster is...

JeepHound (6/18/2014)

---

I would personally start with going into SQL Configuration Manager on each node and shut down the SQL services. This may not be necessary but it seems like...

You're welcome.

The developers should know how to do this, or figure it out.

Here's the class that they would use in their code:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection(v=vs.110).aspx

Good luck

Yes, it would work in the code. They are establishing the sql connection inside the code and provide the server name parameter to the connection string. There shouldn't...

I'm in a .net shop and there are never issues with the named instances for connections. The connections are usually in the web.confg or appconfg files but who knows...

What are you looking to gain by doing it this way? Are each IP on a different NIC?

For the additional instance, the connection would just be:

myservername

myservername\sql2

myservername\sql3

or

myservername,portforinstance1

myservername,portforinstance2

myservername,portforinstance3

or

myservername,port1

myservername\sql2,port2

myservername\sql3,port3

or the above replacing...

No.

The IP address for the SQL Server Instance is the IP address of the server. The physical server will only have one IP address. If you have multiple...

How about using the "work as a group" option, so your team can figure it out together? Part of becoming a DBA is being able to work with a...

gbritton1 (4/25/2014)

---

It's likely that there will be a 1x1 mapping between Employee and voice Telephone numbers. So, keeping them in one simple table could be OK. Fax numbers...

BACKUP DATABASE xxx