Click to See Complete Forum and Search --> : SQL Server won't work


Nate1
01-22-2008, 12:43 AM
Im trying to test the tinyMCE image manager and see whether it works on IIS because its not working on the VS2005 built in server (whether theres a difference Im not sure), IIS is serving pages, but I can't connect to the database using the connection string from the version that works on the VS2005 built in server. Hope that makes sense.

Cannot open database "omni_test" requested by the login. The login failed.
Login failed for user 'OMNINZ-EB708178\ASPNET'.

Public Shared Function Connection() As SqlConnection
Dim sConnection As String = System.Configuration.ConfigurationManager.AppSettings("ConnectionString")
Return New SqlConnection(sConnection)
End Function

<add key="ConnectionString" value="Server=OMNINZ-EB708178\SQLEXPRESS;Database=omni_test;Integrated Security=True" />


What do I do?