SQL Connection Windows 7

R Cockburn

Honorable
Feb 12, 2014
3
0
10,510
Good Day

I have a workstation that we have installed SQL Express 2008 R2 on. We do not have a server which we log onto, all workstations are linked LAN and automatically assigned IP address. The server statically assigned. 192.168.0.156 Able to ping and see this workstation on the net.
When trying to connect via SQL Server name and SQL instance correct. Have done all the tutorials on allowing TCP/IP and given a TCP port 1433, have also created a rule to allow access in the firewall with all the readily available document on the net, yet still no access?
Someone had metioned that it may be that there is not a guest account on the Operating System to allow access?

Any help most welcome
Regards
Richard
 
You didn't specifiy what kind of authentication you set up or what if any error messages you are getting. You can normally use SSPI (windows accounts) or add SQL users. You may also need to set up permissions on any databases/tables/objects you created.

Other than that, I'm not sure what else to look for.
 

R Cockburn

Honorable
Feb 12, 2014
3
0
10,510
Good Day

The error which i have to resolve is that on our network we only have work groups, these work groups may vary from all the workstations linked on out local network. On SQL 2008 R2, Under security i have "SQL Server and Windows Authentication Mode" Enabled. If i Use SQL Authentication i can link to the SQL Server, But have to log on the whole time. For Windows Authentication the SQL sever does not want to accept the user? These users could be various? How does one configure this? In the operating system does it use the guest user for the local server? Or is there a configuration to tell the SQL server to use the Guest account? for external access?

The error generated when trying to connect with Management studio is (Microsoft SQL Server, Error: 18452)

Thanks
Richard
 

R Cockburn

Honorable
Feb 12, 2014
3
0
10,510
Good Day

Thanks for your assistance
I see that on a SQL tutorial which i had read, most of the authorities are always directed at a domain, obviously because of security reasons. I did manage to come right, but cheated in regards as i have used a SQL logon profile. I have done quiet of bit of development in .net and SQL, but there i always create user profiles in code and check my own authorities and create new records for new users. I see that i will have to study a bit on workgroups in the future.
Creating local user accounts on the workstation does work, but creates a bit of admin work for new users.
Appreciate the assistance

Enjoy your weekend ahead.

Cheers
Richard