| Author |
Topic |
|
jeer
Starting Member
32 Posts |
 Posted - 2008-03-27 : 06:24:31
|
| When I connect using SQL SERVER MANAGEMENT STUDION, i get following error:The type initializer for 'AsyncWmiBinding' threw an exception. (Object Explorer)Additional Information: unable to load 'sqltoolsvsnativehelpers.dll': Access is denied. (Exception from HRESULT: 0x80070005(E_ACCESSDENIED))(Object Explorer)Please guide me to resolve this problem.Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-03-27 : 07:04:16
|
| What os are you running on your m/c?The access denied sounds a bit like you don't have permission to run it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jeer
Starting Member
32 Posts |
Posted - 2008-03-27 : 23:18:41
|
| I am using windows xp with service pack 2 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-27 : 23:30:23
|
| Do you have proper permission on the machine? |
|
|
|
jeer
Starting Member
32 Posts |
Posted - 2008-03-27 : 23:49:51
|
| Yes, I got proper permissions.2 days ago, every thing was fine, then from yesterday, this problem occurs |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-28 : 23:52:23
|
| Anyone made change on the machine? Can you load ssms on other machine? Tried reboot it? |
|
|
|
jeer
Starting Member
32 Posts |
Posted - 2008-03-31 : 00:02:07
|
quote:
Originally posted by rmiao
Anyone made change on the machine? Can you load ssms on other machine? Tried reboot it?
what do u mean by ssms? and how can we load it? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 00:09:02
|
| SQL server Management studio |
|
|
|
jeer
Starting Member
32 Posts |
Posted - 2008-03-31 : 00:13:32
|
quote:
Originally posted by sodeep
SQL server Management studio
i rebooted my computer, still the problem exist. please guide me to resolve this problem.we are using sql server 2005 and asp.net on the front end. users can enter data and retrieve data by using the front end but when i connect to SQL server Management studio, then i get the error |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-31 : 22:47:01
|
| Do you have other sql2k5 client machine? Try run ssms from them if so. If not, reinstall sql2k5 tools. |
|
|
|
jeer
Starting Member
32 Posts |
Posted - 2008-04-02 : 02:22:10
|
quote:
Originally posted by rmiao
Do you have other sql2k5 client machine? Try run ssms from them if so. If not, reinstall sql2k5 tools.
which sql2k5 tools should I install? and if I install sql2k5 tools then what will happen to database and my dot net application? will everything be right? |
|
|
|
jeer
Starting Member
32 Posts |
Posted - 2008-04-02 : 02:28:02
|
quote:
Originally posted by rmiao
Do you have other sql2k5 client machine? Try run ssms from them if so. If not, reinstall sql2k5 tools.
I have another client machine but sql2k5 client tools are not installed on it. I am new to SQL Server, please guide me that if i install sql2k5 client tools on other machine then which client tools should I install and how can these client tools will detect the sql2k5 on server machine? and in case, if I have to install sql2k5 tools on server machine then which tools should i install and what will happen to database and my dot net application? will everything be right?Please guide meBest regards |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-02 : 23:18:30
|
| You can install all tools, will not hurt sql server at all. You connect to sql server in same way, no matter on client machine or on server directly. |
|
|
|
jeer
Starting Member
32 Posts |
Posted - 2008-04-03 : 01:59:04
|
quote:
Originally posted by rmiao
You can install all tools, will not hurt sql server at all. You connect to sql server in same way, no matter on client machine or on server directly.
should i install sql native client? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-03 : 23:12:58
|
| Yes, client talks to server with it. |
|
|
|
dbradley
Starting Member
9 Posts |
Posted - 2008-04-19 : 18:56:15
|
| Thank you for your reply. Is there a separate install available just for the SQL Server 2005 Client?David |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-19 : 19:58:29
|
| Yes, tools directory in the dvd or on separate cd. |
|
|
|
|
error while connecting to SQL Server Management St