March 16, 2013 at 11:41 am
Hello everyone,
I am having an issue and I am not sure why. I have every thing set properly I believe, I have an AD DC, The SQL Server is joined properly, I have the Server Action Account set properly. There is no Firewall on the SQL Server and the Server that I am trying to make the connection from is joined to the AD fine. The user account envolved is added correctly. It does btw have to be added local administrators group on the sql box for this app to work.
I really do not want to re install all over again, also the named pipes and tcp/ip are enabled on the sql server, also the allow remote connections is enabled also.
I don't know where else to look to fix this issue,
The server envolved is a vm on an EXi 5.1 host w/2 gb of ram a 40 gb system drive, 40 gb data drive, 20 gb log file drive and 20 gb PageFile drive. I hope that is enough information.
Sorry guys my kb has some keys that stick so I make typos occasionally.
Thanks in advance,
March 17, 2013 at 3:17 am
Are you getting a specific error? Are you connecting to a default instance or a named instance? Try both. Also try just supplying the IP address instead of the server name.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 17, 2013 at 3:39 am
How are you attempting to connect, SSMS? All services running? Can you connect with a sql login?
'Only he who wanders finds new paths'
March 17, 2013 at 8:31 am
david.alcock (3/17/2013)
How are you attempting to connect, SSMS? All services running? Can you connect with a sql login?
Well I noticed that the SQL Server Agent wasn't running. So I restarted it. However I did check all the services and it appeared they all were running. I checked all log files as well for pertinent errors there were none. So I am now at a loss.
March 17, 2013 at 8:35 am
david.alcock (3/17/2013)
How are you attempting to connect, SSMS? All services running? Can you connect with a sql login?
I tried with SSMS from a remote system. To no avail. I tried both Windows Authentication and SQL from the said remote machine and nothing. I could however login at the console of the SQL Server.
Thanks for your help guys.
March 17, 2013 at 8:56 am
OK, SQL Agent is for jobs so non essential, or rather not related to this problem. SQL Browser would be the one to check. Can you post the exact error message?
'Only he who wanders finds new paths'
March 17, 2013 at 9:23 am
david.alcock (3/17/2013)
OK, SQL Agent is for jobs so non essential, or rather not related to this problem. SQL Browser would be the one to check. Can you post the exact error message?
I think it is application realted, I am trying to install VeeamONE Server and It doesn't see the server at all. IT sees my old sql server which is no longer on the network. I have attached screen shots.....
Here are the links ->
http://www.coopfire.com/images/VeeamONE-SQL_ERROR1-SERVICE_ACCOUNT.JPG <-- From remote machine with Windows Authentication
http://www.coopfire.com/images/VeeamONE-SQL_ERROR2-SA.JPG <-- From remote machine with sa account
http://www.coopfire.com/images/SQL_Console1.JPG <-- From the console
Thanks Again,
Michael
March 17, 2013 at 9:53 am
nexusguy59 (3/17/2013)
david.alcock (3/17/2013)
OK, SQL Agent is for jobs so non essential, or rather not related to this problem. SQL Browser would be the one to check. Can you post the exact error message?
So I figured out it has to be at the SQL Server I tried to make a connection from another remote machine and got the same result.
So back to the drawing board.
Thanks,
March 17, 2013 at 10:02 am
FYI, If you are trying to connect remotely to an SQL server the SQL Server browser must be running otherwise it denies your connection as it can not browse db objects.
Lesson Learned.
Thanks guys for trying to help I appreciate it very much.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
