Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SSMS client installation problem

Author  Topic 

chinna1214
Starting Member

21 Posts

Posted - 2015-01-12 : 01:11:31
Hi all,
I want to install ssms client in my system inorder to connect to the server located in different location. But the installation is geting failed showing error "setup account privelages - failed".

I have assigned backup files and directories, manage audit and security log, debug programs rights to my system. i have added my system in all the 3 groups. and i tried rerun bt still it is showing the same. Please help me out.

Harish

Harish

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-01-12 : 12:25:46
Run the installation as an administrator. Use the run as option too.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

chinna1214
Starting Member

21 Posts

Posted - 2015-01-13 : 07:15:53
Thanks it got installed when i restarted the machine. No issues with the installation. Now i come up with a problem that the server is located in remote location so i was tryin to login to it from client installed in my system. The server edition sql 2014 version and i was trying to connect it through 2012 client. Its not getting connected showing error-40 (Naming pipes), i tried it from another machine by installing 2014 client its working fine there. Whats the issue..

Harish
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-01-13 : 12:49:52
Try connecting with ServerName,PortNumber where PortNumber is the port SQL Server is listening on. This is just a test to see if it's a firewall or network issue.

You can find the listening port in the SQL Server Error Log, also in SS Configuration Manager and the registry.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

chinna1214
Starting Member

21 Posts

Posted - 2015-01-14 : 00:21:25
I tried to open the SS Configuration manager. But in there its not showing any services.

Harish
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-01-14 : 12:00:46
You would open it on the server, not your client machine.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -