Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Setting up SQL sever?

Author  Topic 

JohnCash1
Starting Member

39 Posts

Posted - 2012-10-13 : 09:31:43
I have installed the software and
I 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 it
Does 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
Go to Top of Page

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) etc
which 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?
Go to Top of Page

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/
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 2012-10-13 : 21:29:40
Anybody??
Go to Top of Page

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 client

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 2012-10-14 : 22:36:19
http://www.youtube.com/watch?v=DLrxFXXeLFk

here 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.
Go to Top of Page

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?
Go to Top of Page

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 Microsoft

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

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 dl
sQL 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/
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 2012-10-15 : 21:16:55
what do you think about this?
Go to Top of Page

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.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-10-16 : 01:32:00
Follow this link - which has a downloadable version of SQL Server Express 2008 R2 - and is compatible with Windows Vista
http://www.microsoft.com/en-gb/download/details.aspx?id=30438

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

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/
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 2012-10-16 : 16:49:16
Let me know what you think.
Go to Top of Page

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.
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 2012-10-16 : 23:47:14
i downloaded and connect to local and I have an error.

here is an image of error.

http://postimage.org/image/yq22i42ml/

how can I connect to database ?
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 2012-10-17 : 11:24:58
Let me know. thx
Go to Top of Page

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.
Go to Top of Page

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/
Go to Top of Page

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.
Go to Top of Page
    Next Page

- Advertisement -