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.
| 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/ |
 |
|
|
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 |
|
|
|
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/ |
|
|
|
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 |
|
|
|
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/ |
|
|
|
|
|
|
SSMS client installation problem