April 16, 2014 at 6:16 am
Hello everyone
I have 2 new servers WS 2012 R2 in cluster, on them i installed 2 instances in cluster SQL SERVER 2008 R2. On 1 instance i created a database "TEST", i wanted to test this database in our programs but in place wher i point sql server for the program i got SERVER NAME on which is sql in cluster instead SQL NETWORK NAME ;/ Now is the problem when i choose SERVER NAME i get error because he don't see the database but when i manualy typ SQL NETWORK NAME i see database and i can start the program. Plz help. Sry for me english.
April 16, 2014 at 6:31 am
How are you "pointing" SQL Server? Is this an attempt to connect via SSMS or an actual connection string in a program?
When you say "but in place wher i point sql server for the program i got SERVER NAME on which is sql in cluster instead SQL NETWORK NAME", do you mean you're putting in the wrong name and can't figure out the correct one?
SQL Servers are usually referred to as SERVERNAME\INSTANCENAME. In the case of a virtual name (where you might have a clustered server, so you don't want to refer to the specific server name), you would use VIRTUALSERVERNAME\INSTANCENAME.
You might also need to reference the port number. Default SQL port # is 1433, so you might end up with VIRTUALSERVERNAME\INSTANCENAME,1433 or SERVERNAME\INSTANCENAME,1433 as your connection string.
Lastly, check the permissions on the new database. If they haven't been created, then all the pointing in the world isn't going to help because the program won't be able to connect to the server.
April 16, 2014 at 6:45 am
We use a database program "Wf-Mag", on login screen i can choose a sql server ( wher should be a network name of me sql instance but i got name of me server from cluster) and a database from sql server.I choose sql server from the list, ther i have me old sql server "sql server name" and it works and i have "domain name of me cluster server" which don't works.
April 16, 2014 at 7:59 am
Does it not give you the option of entering your own server name?
If not, double-check that SQL Server Browser Service is enabled on the server (if it's a new server, it might not be, or it might not be replicated through your domain) and that the account using this interface has permissions on that sql server and the database.
April 16, 2014 at 8:15 am
I can enter own server and it works, but this is not solution.
April 16, 2014 at 8:22 am
Beyond repeating what I've told you about permissions and SQL Server Browser Service, the only other thing I can recommend is that you call your software vendor or go to their website and look up their support forums.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply