SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Setting up SQL sever?
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

JohnCash1
Starting Member

39 Posts

Posted - 10/13/2012 :  09:31:43  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
1911 Posts

Posted - 10/13/2012 :  11:28:06  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 10/13/2012 :  12:49:57  Show Profile  Reply with Quote
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 - 10/13/2012 :  12:53:22  Show Profile  Reply with Quote
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 - 10/13/2012 :  21:29:40  Show Profile  Reply with Quote
Anybody??
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1911 Posts

Posted - 10/14/2012 :  12:05:46  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 10/14/2012 :  22:36:19  Show Profile  Reply with Quote
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 - 10/14/2012 :  23:37:38  Show Profile  Reply with Quote
I don't think I install SQL server engine on my machine.

how and what is it for?
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1911 Posts

Posted - 10/15/2012 :  01:46:38  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 10/15/2012 :  03:00:44  Show Profile  Reply with Quote
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 - 10/15/2012 :  21:16:55  Show Profile  Reply with Quote
what do you think about this?
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 10/15/2012 :  22:26:48  Show Profile  Reply with Quote
I have a hard time installing the SQL server express.
it seems not compatible with my window vista.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1911 Posts

Posted - 10/16/2012 :  01:32:00  Show Profile  Visit jackv's Homepage  Reply with Quote
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

Edited by - jackv on 10/16/2012 01:32:22
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 10/16/2012 :  08:14:41  Show Profile  Reply with Quote
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 - 10/16/2012 :  16:49:16  Show Profile  Reply with Quote
Let me know what you think.
Go to Top of Page

robvolk
Most Valuable Yak

USA
15636 Posts

Posted - 10/16/2012 :  17:09:00  Show Profile  Visit robvolk's Homepage  Reply with Quote
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 - 10/16/2012 :  23:47:14  Show Profile  Reply with Quote
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 - 10/17/2012 :  11:24:58  Show Profile  Reply with Quote
Let me know. thx
Go to Top of Page

robvolk
Most Valuable Yak

USA
15636 Posts

Posted - 10/17/2012 :  11:35:39  Show Profile  Visit robvolk's Homepage  Reply with Quote
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 - 10/17/2012 :  12:19:25  Show Profile  Reply with Quote
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

USA
15636 Posts

Posted - 10/17/2012 :  15:05:44  Show Profile  Visit robvolk's Homepage  Reply with Quote
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
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000