|
-
Dec 26th, 2020, 07:59 PM
#1
Can't Find SQL Server-REVIVED
I have something set wrong, but I'm not sure what.
I have two computers that connect to a database located on the third computer. For one of them, all is well. I had to open a port on the computer that hosts the SQL Server such that others could discover it, but I don't recall doing anything at all on the computer that is having no issues.
On the other computer, SQL Server Management Studio doesn't see the server at all. However, in the program, I look for all instances of SQL Server and it shows both of the versions on that DB server (it has SQL Server 2012 and 2017...or whatever is most recent). However, it won't connect using the proper credentials.
The way I am looking for SQL Server is with this code:
Code:
Dim dSourceInstanct = SqlDataSourceEnumerator.Instance
mDTServers = dSourceInstanct.GetDataSources
again, this does find the SQL Server instances, I just can't connect to them using correct credentials, and SSMS doesn't even see them.
What setting do I have incorrect?
Last edited by Shaggy Hiker; Jan 4th, 2021 at 05:32 PM.
My usual boring signature: Nothing
 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote