Hi, I've been Searching the Net for hours now, and i can't really seem to find anything clear and straight to the point.
I need to create a Server/Client application using VB.net 2008, it's actually my first time to have a database on another computer. So I first searched the internet for the things i need to make this software.
-MSSQL Server 2008 (Not R2)
-Vb.Net 2008 Express Edition
-A Desktop (Client)
-A Laptop (Server)
- 1 Crossover Cable
What i have managed to do so far:
1. I have Connected and Established a connection between the two Computers and "Pinged" them using cmd> ping 192.168.X.X and they both replied.
2. I Created a Database on the Server(Laptop) using MSSQL Server 2008 and named it "Network18".
3. I made a Simple Form and a button in the Client (Desktop).
4. I wrote this code in order to test the connection between the two computers..
Imports System.Data.SqlClient Public Class Form1 Dim Sqlcon As SqlConnection Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Sqlcon = New SqlConnection("Data Source=MyComputerName\SQLEXPRESS;Initial Catalog=Network18;Integrated Security = True") Sqlcon.Open() End Sub End Class
("Please do check if i'm missing something")
I don't think something is wrong with my code, but every time I try to execute the software from the "Client", in order for me to test if i made the connection successfully, i get this error..
Login failed for user 'MyComputername\Guest'.
so i searched the net for some clues and read about an article about the the authentication of my database. so i checked again my authentication and i saw that it's set in Windows Authentication, which i think is correct. but when i try to remove the "\SQLEXPRESS" together with the mycomputername it just gives the network connection error.
I tried turning off my AV + my Firewall, Made some changes in the users in MSSQL management studio, tried Reseting the SQL Server from services.msc.. still the same error.
so, can anyone help me on this one.. i've spent all morning trying to figure out where i went wrong. any help will be appreciated thanks!