Everything will work fine – until you have a failover. The database-level user information gets replayed on the secondary servers, but the login information does not. you may have created a new login or associated a user with a login on the primary database. After establishing mirroring, Availability Groups, log shipping, etc. Note that this could also be a symptom of an orphaned login. This is reported as state 27 or state 16 prior to SQL Server 2008. I came across this once when I typed here instead of picking that option from the list. The database specified in the connection string, or selected in the Options > Connection Properties tab of the SSMS connection dialog, is no longer valid or online (it might be set to AutoClose or the user may simply not have permission). Reason: Cannot open database '' requested by the login. Reason: Failed to open the database specified in the login properties. Taken from Aaron Bertrand's blog post on the state values for error message 18456:ģ8 Error: 18456, Severity: 14, State: 38. Just because you are authorised to connect to a certain database on a certain server, does not mean that you authorised to connect to any database. The problem is when i made the string connection and try put the server and instance What are you connecting to in this case? A local database? I have a connection in my project and works perfect, Using writer = XmlWriter.Create(FILENAME, settings)Ĭonsole.WriteLine('File '' has been created.', FILENAME) Settings.Encoding = New UTF8Encoding(False) Using reader As XmlReader = cmd.ExecuteXmlReader()ĭim xdoc As XDocument = XDocument.Load(reader) Using cmd As SqlCommand = New SqlCommand()Ĭmd.CommandText = 'SELECT TOP(2) * FROM Person.Person FOR XML PATH('r'), TYPE, ROOT('root')'

Using con As SqlConnection = New SqlConnection(builder.ConnectionString)

Const FILENAME As String = 'e: empile_.xml'ĭim builder As SqlConnectionStringBuilder = New SqlConnectionStringBuilder()īuilder.InitialCatalog = 'AdventureWorks2012'īuilder.ApplicationName = 'Wonderful application'

Ms sql error 18456 state 5