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.HarishHarish |
|
|
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 KizerSQL Server MVP since 2007http://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 KizerSQL Server MVP since 2007http://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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
SSMS client installation problem