Getting the following error on running the connection code below:
SQLException was unhandled "Login failed for user 'D37YKC1S\Guest'."
No doubt it is a security problem but I am not sure how to get around it. Any help appreciated.
Connection code:
Dim conn As New SqlClient.SqlConnectionconn.ConnectionString =
"Server=D37YKC1S\SQLEXPRESS;Integrated Security=True;Database=VBNMDATA"conn.Open()
Tried the following which is my Windows logon on the other computer (blank password) but same error:
conn.ConnectionString = "Server=D37YKC1S\SQLEXPRESS;Integrated Security=True;Database=VBNMDATA; User Id=Geoff; Password="
I have TCP/IP enabled in SQL Express and the firewall is off. I can see the server on the other computer with this code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ' Retrieve the enumerator instance and then the data. Dim instance As SqlDataSourceEnumerator = _SqlDataSourceEnumerator.Instance
Dim table As System.Data.DataTable = instance.GetDataSources() ' Display the contents of the table.DisplayData(table)
End Sub Private Sub DisplayData(ByVal table As DataTable) For Each row As DataRow In table.Rows For Each col As DataColumn In table.ColumnsMessageBox.Show(col.ColumnName.ToString &
" " & row(col).ToString) Next Next End Sub
Network access SQLExpress
Esand15
You don't have to change registry keys to enable mixed authentication. You can use Management Studio to do this. See instructions at: http://msdn2.microsoft.com/en-us/library/ms188670.aspx.
Could you provide more information about how BOL broke Management Studio I suggest you also file a bug at http://lab.msdn.microsoft.com/productfeedback/Default.aspx.
Note that Books Online is also available online at: http://msdn2.microsoft.com/en-us/library/ms130214(en-us,SQL.90).aspx.
Thanks
Laurentiu
wds123456
Thanks. I installed BOL but it broke SQL Server Management Studio Express CTP so I will download to another machine.
Regards,
GS
Lazarus Islo
YOu have to create a new login for a WindowsUser you are connecting with (at this time the Guest user) and give himappropiate permissions on the database. Look for "CREATE LOGIN" in the BOL and additionally for granting rights on the db "CREATE USER) and on the appropiate objects "GRANT".
HTH, Jens Suessmeyer.
ChrisK0533
Thanks again. I have VB Express and SQL Express installed along with Management Studio CTP and all working well. I installed the latest BOL and when trying to run Management Studio nothing at all happens, no error, just a blank screen. I did a search on the forums and this is not an uncommon problem and I assumed MS was aware of it. Uninstalling BOL fixed the issue. I will file a bug report as you suggested.
See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=180792&SiteID=1
Regards,
GS
Seglberg