hi i have a problem with my database

Question

hi i havea system and i have a error with regarding to my database..when i try to other laptop of my system then i will run .exe and this is my error.

pls help me about this my error...

 

 

 

 

Answer 1

by the way this is my code for connction of my database 

Sub connect()

        If sqlconn.State = ConnectionState.Open Then sqlconn.Close()

        sqlconn.ConnectionString = " server= Ryan-Pc;database=DRMM_Student_Database;integrated security=true"

        sqlconn.Open()

    End Sub

Answer 2

Do you want discuss or is this a question? ;-)

If you try from the server where the sql server is running, all works?

If so, seems that the SQLServerBrowser Service is not running.

Answer 3

this is question sir..which I just made my database Its work but when i try to other laptop my database cannot open.then i try to reattach my database my vb2010 will not detect my database..

Answer 4

Windows login Ryan-Pc\Ryan does not have permissions on database DRMM_Student_database. grant the permisions on database.

---

http://uk.linkedin.com/in/ramjaddu

Answer 5

but my system its work where i made my system..my problem is when i try to the other computer its not work..what other way to open my database to the other computer??

Answer 6

but when i try to copy the database and i will paste to the debug folder its work..but my probelm is i cant see the table in to the vb..

Answer 7

1- Connect to your server through SSMS, right-click on server entry in Object Explorer pane, and select Properties. Then select Connections tab and make sure "Allow remote connections to this server" is selected.

2- type Services.msc in windows run, and hit enter. Locate "SQL Server Browser" service and make sure it is started.

---

http://thebipalace.wordpress.com

Answer 8

what is the purpose for that??..i try that you give  procedure but in step 2 when i enter the sql server browser??what nxt..

Answer 9

The purpose of second point is to check whether SQL Browser service is started. You don't need to enter SQL Browser. Just check if the service is started. If not, right-click on SQL Server Browser in Services window and select Start.

---

http://thebipalace.wordpress.com

Answer 10

could you please confirm whether your System and the other laptop is part of a DOMAIN (or) workgroup.

If there are not part of any domain then they are part of a workgroup then you need to use SQL Server aythetication.

you can also try a ODBC test from the laptop do your desktop with SQL Authentication first .

 

 

 

---

MCTS/MCITP (SQL Server 2005, 2008, 2005 BI)

Answer 11

Ryan

when i look at the error message it says the login failed for Ryan-pc\Ryan

In this Ryan-pc is the computer name the next word Ryan is IT A SQL Account ?

One thing we need to remember that if the two computers are not in a domain the only way we can make it to authenticate is through SQL Server authentication. There are other ways which will work if the computers are in a domain network.(Kerberos , NTLM)

For this we need to create a SQL Server user account called Ryan within the SQL Server database on Ryan-pc. then on the laptop when try to connect do not use Integrated security.

Integrated security will work if the computers are on a domain network.

Ryan-PC\Ryan account is valid only on that local computer not accross two computers.  in order to make this work between two computers which is not part of a domain

 create a SQL Account in SQL Server (Ryan-pc)

On the other computer where your trying to connect use sql Authetication . Before try to connect through the applicaiton residing in another box. First try to use the ODBC (or) UDL Test from the laptop.

Try to create a simple ODBC connection from the laptop to the Ryan-pc use create a system dsn fill the server details along with the port number and choose with sql authentication. provide the sql login account that you have created in the ryan-pc and click next .

You should  first get the test completed sucessfully. IF this is not sucess do not tourbleshoot the application first . first we need to get this work.

 

 

 

 

 

 

 

---

MCTS/MCITP (SQL Server 2005, 2008, 2005 BI)