Showing posts with label managed. Show all posts
Showing posts with label managed. Show all posts

Monday, March 19, 2012

Can''t deploy managed assembly to Katmai

Hi!

When I create a managed assembly database project inside Visual Studio 2005 and want to change the database connection to a Katmai server, I get the following error message:

"This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later."

Is this a bug inside Katmai or Visual Studio 2005?

Thanks

Klaus Aschenbrenner

http://www.csharp.at

http://www.csharp.at/blog

Hi Klaus!

That is a bug/feature/something in the VS deployment project :-). You can either deploy manually or use my deployment project from inside VS.

Niels

Can''t deploy managed assembly to Katmai

Hi!

When I create a managed assembly database project inside Visual Studio 2005 and want to change the database connection to a Katmai server, I get the following error message:

"This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later."

Is this a bug inside Katmai or Visual Studio 2005?

Thanks

Klaus Aschenbrenner

http://www.csharp.at

http://www.csharp.at/blog

Hi Klaus!

It's a VS thing. You can either deploy manually, or use my deployment project from within VS to deploy.

Niels
|||

Hi Klaus,

This is a known issue with Visual Studio 2005 / 2008 beta. This will be fixed in a future release of Visual Studio.

As suggested by Neils, you can build your assembly through Visual Studio and deploy it using CREATE ASSEMBLY/CREATE FUNCTION statements from management studio.

Let me know if you need more information.

Thanks,

-Vineet

Tuesday, February 14, 2012

Cant connect to server

Hey,
I've had a server running for the last couple of months and earlier today it died, i managed to get Service Pack 2 on it, and now it will start but nothing will interface with it,
especially not coldfusion

Coldfusion says
SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.

though when i use ODBC and i set a new DSN
if i use Windows Authentication, it goes through, and i test the source and it says succesful
though if i try and use SQL Authentication it says

Connection Failed :
SQL State : '28000'
SQL Server Error : 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for 'username'. Reason : User not associated with a trusted SQL connection

any ideas?Is your sql instance set up for windows only authentification or mixed-mode ?|||Originally posted by rnealejr
Is your sql instance set up for windows only authentification or mixed-mode ?

its ok
sorted it now, it was for SQL Authentication, not mixed or windows

i rebuilt the registry and it worked