Last post Feb 24, 2015 08:37 PM by Edwin Guru Singh
Feb 23, 2015 09:56 AM|ts-alan1|LINK
I am using a SQL express databases in Visual studio 2013.But when i connect to sql express, open server explorer and trying to create a table, i see visual interface sql server db .Any
It's on another computer in visual studio 2012
In my machine
Feb 23, 2015 11:47 PM|Edwin Guru Singh|LINK
As per your case, the following steps which may fulfill your requirements :
1,To view the SQL express,Click on ‘View’ -> ‘Server Explorer’.
2, Right Click on ‘Servers’ and select ‘Add a Server’.
3, Write Server Name in the Dialog, In this case, you have to write your machine name
4,To create a database,Right Click on Data Connections and select “Create SQL server database”.
5, In the dialog box, select server name from the list, select the authentication you want to use and provide a new database name.
6, To create a connection,Right Click on Data Connections and select “Add Connection”.
7,In “Choose Data Source” dialog box, select “Microsoft SQL Server”, data provider will get filled simultaneously. Click continue.
8, Fill Connection properties in the dialog box, select server name from the list. Once server is selected, “Connect to database” section gets activated, select database and click “Test Connection”.
Feb 24, 2015 01:58 AM|ts-alan1|LINK
it does not work
Feb 24, 2015 02:45 AM|Edwin Guru Singh|LINK
it does not work
Feb 24, 2015 03:40 AM|ts-alan1|LINK
Did you face any error message ?
Feb 24, 2015 08:37 PM|Edwin Guru Singh|LINK
then what is the problem ?
please explain it clearly because its more helpful us to fix your issue.