question

Donald-0878 avatar image
0 Votes"
Donald-0878 asked ErlandSommarskog answered

Using SQL Server Management Studio

May I please ask, if using SQL Server Management Studio can work without having SQL Server installed in a development computer?
I have been trying to connect using SQL Server Management Studio but I keep getting error
"A network-related or instance-specific error occurred while establishing a connection to SQL Server"

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

Yes, you can use SSMS without having SQL Server installed locally. You can connect to any SQL Server instance you can find on the network.

You say that you want to connect to your production server from your development machine. I think you need to discuss how to do this with the DBA or your IT department. We don't know any details about your environment, so we cannot really help you with those details. However, it is not impossible that the network is configured in such a way that you cannot connect directly to the SQL Server instance from your development machine for security reasons.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NaomiNNN avatar image
0 Votes"
NaomiNNN answered Donald-0878 edited

Are you using Windows Authentication or SQL Server authentication?

You don't have to have a local instance of SQL Server on the development machine provided that you can access your stage or production server from the development computer.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

That's the point, I can't access the production server from my development machine.
I installed SSMS and tried to connect but it's the sake error message that pops up every time. I thought it's was due to the absence of SQL Server, so I downloaded and installed SQL Server. It's frustrating. Please I need help

0 Votes 0 ·

I actually used SQL Server Authentication. Could this be the problem?

0 Votes 0 ·