Author |
Topic |
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-13 : 09:31:43
|
I have installed the software andI have the datas etc, how do I make the Microsoft software usable?Does it need to connect to a server to be use?If not how, or if itDoes how can I connect it to a sever?Thanks |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-10-13 : 11:28:06
|
If you are connecting from SQL Server Management Studio (SSMS) then you will need a SQL Server to connect. Usually the server name is : myserver\myinstance and then a logon.Have you installed SQL Server on your computer? Have you started the service?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-13 : 12:49:57
|
I have the SSMS software downloaded on my personal computer locally. I noticed I couldn't use it because it need some kind of server connection (server name) etcwhich I don't have.Can it be use locally or does it need to be set up to a server for the software to be use? If so, how can I set up a server on my personal computer locally so I could use it? |
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-13 : 12:53:22
|
here is the image of what my SSMS looks like. I downloaded, and open the software but I can't use it.http://postimage.org/image/ocm3j7hl1/ |
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-13 : 21:29:40
|
Anybody?? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-10-14 : 12:05:46
|
You now need a SQL Server Instance to connect to. Did you install the SQL Server Engine on your machine? You can check this by checking the services. To attach to the services - from the command line type "services.msc". Look for a SQL Server service. Alternately , is there another SQL Server you can attach. The picture you're showing is the SSMS - which is a clientJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-14 : 22:36:19
|
http://www.youtube.com/watch?v=DLrxFXXeLFkhere is a video of how to get to the instance location and see if I have an instance. As for the video I went to the configuration tools and SQL server configuration manager and I see no instance. Here is an image: http://postimage.org/image/lialc0gjj/I also went to command line and type "services.msc" and look for SQL server service and I don't see it. |
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-14 : 23:37:38
|
I don't think I install SQL server engine on my machine. how and what is it for? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-10-15 : 01:46:38
|
The SQL Engine provides the Database Server Service. If that is not installed than you cannot connect to a Database Engine on your computer. You can of course , connect to another SQL Server Instance. Remember : SSMS is a client. To intall the SQL Server Engine you can download SQL Server Express (free) from MicrosoftJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-15 : 03:00:44
|
so I could only connect to the Database engine by installing the SQL server engine by dlsQL server express? Or Database engine is something else, and that server express is another SQL server instance? and do you know anything about DotNetPanel. this article below, talks about DoNetPanel, not sure if is similar to what you say. it says how to use Microsoft sql server 2008 to connect to your database. http://blog.arvixe.com/how-to-use-microsoft-sql-server-2008-to-connect-to-your-database/ |
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-15 : 21:16:55
|
what do you think about this? |
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-15 : 22:26:48
|
I have a hard time installing the SQL server express. it seems not compatible with my window vista. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-16 : 08:14:41
|
I installed it but I can't seem to open the apps to use it.this is all it has http://postimage.org/image/6pfespzdz/ |
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-16 : 16:49:16
|
Let me know what you think. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-16 : 17:09:00
|
Download and install the Management Studio software from the link provided by jackv.The DotNetPanel is provided by your web host, it won't work for a locally installed SQL Server instance. |
|
|
JohnCash1
Starting Member
39 Posts |
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-17 : 11:24:58
|
Let me know. thx |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-17 : 11:35:39
|
Did you run the SQL Configuration Manager and enable TCP/IP and Named Pipes protocols? You can find them under SQL Server Network Configuration. Once you enable them you need to restart your SQL Server Service, which you can do from the Services section in Config Manager. |
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 2012-10-17 : 12:19:25
|
The TCP and IP is already enable. Here is am image of it. http://postimage.org/image/pez7w2ndz/and how to restart in the SQL server service from configuration manager? I don't see anything that I could press or do to restart it. Here is an image of the SQL server service. http://postimage.org/image/5675lqccr/ |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-17 : 15:05:44
|
Whichever machine you're running Configuration Manager on does not have SQL Server installed, otherwise there would be services listed. |
|
|
Previous Page&nsp;
Next Page
|