Jump to content
Sign in to follow this  
billnva

SQL Server Authentication non default port

Recommended Posts

Running Retrospect 7.7 with SQL Add-in.

 

Using the default SQL 2008 R2 instance port I can authenticate to the instance through restrospect and see al lthe databases. When I change the SQL default instance port Retrospect cannot log into the instance and keeps asking to re-authenticate. I have tried Domain accounts, SA Account, and the RBU and of course turning the firewall on and off. Backwards compatibility feature for SQL 2005 X64 is installed.

 

When I use the default instance port for SQL 1434 there isn't an issue. I would rather not use this port though. The application front end works just fine for the SQL back end that is using the non default port. I have reinstalled the agent, and tried to log in using different accounts with permissions that should work but no go. Am I missing something?

 

Thanks,

 

Bill

  • Like 6

Share this post


Link to post
Share on other sites

Some interesting items to note that made the above work for me. Starting with the configuration as follows:

 

VMWare 5.5 VSphere - SAN Configuration

VM1 Windows 2008 Standard R2 X64 with Windows SQL Server Standard R2 X64 and Retrospect Client 7.7 114

SQL Server backwards compatibility 2005 X64

Retrospect 7.7 Multi Server (Separate Physical Server)

Same Domain

 

Added 3 VMDK Disks to VM1 for SQL Database, SQL Log, and SQL Instance

 

If the VMDK disks are partitioned as GPT at 500GB each then authentication to the SQL instance from Retrospect Multi Server "Login as" fails and re-prompts using Domain Admin or SA Account however,

If the VMDK disks are partiioned as MBR at 500GB each then authentication to the SQL instance from Retrospect Multi Server "Login as" succeeds using Domain Admin or SA Account.

 

Comments?

Share this post


Link to post
Share on other sites

I'm having the same problem as the original post, as we also run a non default SQL port.

 

I don't understand how the partitioning/VM disks would have any affect strange that it now works for you.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×