error trying to connect to SQL Server

[ryan010101]

I'm trying to upsize an Access db to a SQL Server db on my ISP, but I am getting this error:

Microsoft Visual C++ Runtime Library
Assertion Failed
Program: ...RAM FILES\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE
File: .../scr/sqlsspi.c
Line: 119

Expression: Count

For info on how your program can cause an assertion failure, see the Visual C++ documentation on asserts

Abort Retry Ignore

I hit Ignore then I get:

MICROSOFT SQL SERVER LOGIN
Connection failed:
SQLState: 'HY001'
SQL Server Error: 0
[Microsoft][OBDC SQL Server Driver]Memory allocation failure
Connection failed:
SQLState 'HY000'
SQL Server Error: 8
[Microsoft][OBDC SQL Server Driver]Cannot generate SSPI context

My ISP is no help cause they say it's on my end and I looked up "cannot generate SSPI context" on microsoft and there solution (in this article

http://support.microsoft.com/support/kb/articles/Q269/5/41.ASP)

is to get a certain registry key off another machine and install it on mine. Well of course I don't have another machine with that so that really isn't a solution. Any ideas?

Thanks
Ryan

 

[cdukes]

It looks at first glance as if you are trying to connect to SQL Server using integrated security (SSPI) but you are also providing a login name (SQL Security).

Is the SQLServer on the same domain as you are logged into?
Does the SQLServer support integrated security?

Hope this helps,

Chris Dukes

 

[ryan010101]

I signed up for SQL Server on my ISP (interland) and they gave me an ip address, username and password. I then followed their online tutorial on how to upsize an Access database and during this process I am getting the error. The microsoft article suggests using named pipes, but I can't do that with my isp, it must be TCP/IP. I am not logged into anything during the upsize process until the end when I get the error. I'm assuming the SQL Server supports integrated security because my ISP didn't tell me other wise. It appears I need to add a registry key to my machine, but I where do I find this key?

 

[cdukes]

If you are not logged onto the domain at your ISP then you cannot use integrated security (SSPI) as you will be required to have been authenticated by your ISP's domain controller before logging on to SQL Server.

Thus you must connect to SQL Server using SQL Server authentication.

How are you connecting to SQL Server (ODBC, DSN, DSN less).

Have you tried connecting to the database directly, without using the Upsizing wizard?

 

[ryan010101]

I just tried connecting using InterDev and it basically does the same thing. I'm "creating a new data source to SQL Server". When I get to "How should SQL Server verify the authenticity of the log in ID?", I select "With SQL Server authentication using a log in ID and password entered by the user." I then select (still on the same window) "Connect to SQL Server to obtain default settings for the additional configuration options." and enter my ID and password. When I hit "Next" is when I get the error stated above. On that same window under "Client configuration" I have "TCP/IP" selected. Any clue?

thanks for you help,
Ryan

 

[ryan010101]

What do ya know, I fixed it myself. I did a search on microsoft.com for the error code I was getting (SQL Server Error: 8) and actually got a solution that worked. I needed to have "Client for Microsoft Networks" installed on my machine. Did that and it worked fine. Thanks for the help though.

-Ryan