Quote:
Originally Posted by FreakyLikeMe.
als Admin mal ausführen?
|
hab UAC aus
ich denke das es irgendwie an den linked servern oder odbc liegt aber bin mir nicht ganz sicher hab schon mehrmals jetzt versucht die linkedserver neu zu machen hier mal meine sql für den account linked server die anderen sind genauso nur halt mit billing, character01, ranking und log01:
Code:
/****** Object: LinkedServer [ACCOUNT] Script Date: 04/02/2011 23:48:48 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'ACCOUNT', @srvproduct=N'login', @provider=N'SQLNCLI10', @datasrc=N'MY-PC\SQLSERVER', @catalog=N'ACCOUNT_DBF'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ACCOUNT',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'rpc out', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'use remote collation', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'ACCOUNT', @optname=N'remote proc transaction promotion', @optvalue=N'true'
GO
ODBC:
Code:
////////////////////////////
Name:BILL
Type:SQL NATIVE Client 10.0
Server:MY-PC\SQLSERVER
DB:ACCOUNT_DBF
Lang:English
////////////////////////////
Name:character01
Type:SQL NATIVE Client 10.0
Server:MY-PC\SQLSERVER
DB:CHARACTER_01_DBF
Lang:English
////////////////////////////
Name:log01
Type:SQL NATIVE Client 10.0
Server:MY-PC\SQLSERVER
DB:LOGGING_01_DBF
Lang:English
////////////////////////////
Name:Login
Type:SQL NATIVE Client 10.0
Server:MY-PC\SQLSERVER
DB:ACCOUNT_DBF
Lang:English
////////////////////////////
Name:RANKING
Type:SQL NATIVE Client 10.0
Server:MY-PC\SQLSERVER
DB:RANKING_DBF
Lang:English
////////////////////////////