Please help because i don't get it

[bdwalle]

I have buyed a server and yesterday i have installed:

Windows 2003 Server Enterprise
Microsoft SQL Server 2005

If i open session he says:


2068: Session Server Ready
2068: Provider::initialize<>
Microsoft OLE DB Provider For SQL Server: [DBNETLIB][ConnectionOpen <connect<>>.]SQL Server does not exist or access denied.
2068: >> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
2068: File: .\Config\Provider.cpp, Line: 79

Why do i get this

 

[bdwalle]

The server packs not
i respond again if i download the server packs and than work or not..

He does give the error again..
I have download SQL Server 2005 SP3

 

[bdwalle]

I can login with the Account and password ,
Where can i look if he haves enough rights and which rights do he needs?

 

[bdwalle]

By account and billing and cash and character is :

db_owner and public

 

[bdwalle]

Where can i check for more updates?

I have found why he not can connect but now i have a other problem..

For the people that have here is a url:
http://www.stylusstudio.com/SSDN/default.asp?action=9&read=6523&fid=57&style=Inline

But now i have:

224: Provider::Execute< CCHAR * szName >
szName: SP_LOGIN_FLAG_SET
Microsoft OLE DB Provider for SQL Server: OLE DB provider "MSDASQL" for linked server "LSV_DKRACNT" returned message "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen <Invalid Instan>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
244: FILE: .\Config\Provider.cpp, Line 79

Help please..

boopboop

 

[lCON]

Not a fan of mssql 2005 Rather 2000 service pak 4 works really nice.

 

[bdwalle]

but MSSQL 2000 is not downloadable anymore..
If you search on the site of microsoft he says:

Not found..

 

[lCON]

Let me see if I can get it hosted on my dedi. I'll pm you with a link for download if i can. Well not if but when its already there just need to make it download able.

 

[bdwalle]

oo that's great
Thank you..

EDIT: Is it already uploaded?
Than i can work further..

bump

 

[lCON]

Don't keep bumping this section don't get alot of hits no need to bump and it service pack 3 i think. All i updated to mine was sp4 witch is a free download.

 

[bdwalle]

what do you mean with: "it service pack 3 i think. All i updated to mine was sp4 witch is a free download."?

 

[VenT]

I have found why he not can connect but now i have a other problem..

For the people that have here is a url:
http://www.stylusstudio.com/SSDN/default.asp?action=9&read=6523&fid=57&style=Inline

But now i have:

224: Provider::Execute< CCHAR * szName >
szName: SP_LOGIN_FLAG_SET
Microsoft OLE DB Provider for SQL Server: OLE DB provider "MSDASQL" for linked server "LSV_DKRACNT" returned message "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen <Invalid Instan>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
244: FILE: .\Config\Provider.cpp, Line 79

Help please..

run query analyzer and run the script: sp_addlinked server LSV_DKRACNT .for more information please read the guide

 

[chuluia]

reinstall SQL