AndyLee100
Technical User
I am trying to connect to a SQL Server database from a PDA app written in C#.
The server name in the connection string is the dns name\sql instance name.
It will not connect to the database and says 'SQL server does not exist or access denied' or something like that.
However if I swap the dns name for the IP address it will connect ok.
The problem is I cannot use the IP address, it must be the dns name (the customer has insisted on this).
I have tested it in our office and it will work with the dns name but it will not work on our customers site.
Does anyone have any ideas how to fix this or what the problem might be ?
Thanks
Andy
The server name in the connection string is the dns name\sql instance name.
It will not connect to the database and says 'SQL server does not exist or access denied' or something like that.
However if I swap the dns name for the IP address it will connect ok.
The problem is I cannot use the IP address, it must be the dns name (the customer has insisted on this).
I have tested it in our office and it will work with the dns name but it will not work on our customers site.
Does anyone have any ideas how to fix this or what the problem might be ?
Thanks
Andy