SQL Server does not exist or access denied

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server does not exist or access denied

SQL Server does not exist or access denied

Rate Topic

Display Mode

Topic Options

Author

Message

elham_azizi_62

Posted Sunday, January 20, 2013 4:29 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, April 27, 2013 5:33 AM
Points: 109, Visits: 390

hello all.
I run this: declare @h int,@objDBC int,@src varchar(255), @desc varchar(255);

EXEC sp_OACreate 'ADODB.Connection', @objDBC OUT

EXEC @h=sp_OASetProperty 16711422,
'ConnectionString', 'Driver={SQL Server};
Server=WIN-00UO3RQ0BM3;
Database=MaliGilan;
trusted_Connection=Yes'
EXEC @h=sp_OAMethod 16711422, 'Open'
print @h
if @h<>0
EXEC sp_OAGetErrorInfo 16711422, @src OUT, @desc OUT
raiserror('Error 0x%x, %s, %s',16,1, @h, @src, @desc)

but get error :
Microsoft OLE DB Provider for ODBC Drivers, [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
please guide me to solve this problem step by step.
thanks

Post #1409265

« Prev Topic | Next Topic »

Permissions