- Blind-sysadmins - lists.hodgsonfamily.org

Re: [Blind-sysadmins] SQL Server
by Barry Toner 23 Nov '12

23 Nov '12

Hi, Thanks for this info. All of you have been very helpful so far. I'm a complete Newbee in-terms of managing SQL DB's. The most I did at University was query the Databases and Create them using the command line, but I've never worked on the Server stuff. I can't connect to .\sqlexpress. It keeps timing out. When I bring up the SQL Config Man I see in there two Databases that I'm using for an asset management project. However, I don't' want this to use these Databases. I've found a youtube tutorial on SQL which will help me get started. Any ideas why I'm getting the following error though when I'm trying to connect to .\sqlexpress? "Cannot connect to .\sqlexpress. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)" Regards, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Timothy Spaulding Sent: 05 November 2012 12:39 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] SQL Server Hi, When you launch SQL Server Management Studio (SSMS), you are prompted for a server to connect to. In this box, you wound type: Servername\sqlexpress Where servername is the computer you install SQL to. (since you mentioned it was SQL Express you installed) If you are on the same server, you could have easily typed in: .\sqlexpress (that is a period backslash then sqlexpress) To set the authentication mode to mixed mode (supporting both SQL Authentication and Windows Authentication), right click on the server name and select properties. On the left side of this property sheet there is a few choices. Chose Security and tab to a radio button for Mix mode authentication. Then, ok out of the dialog box. To set the SA password, back to the object view where you saw the computer name; this is a tree view. Expand the computer name, arrow down to security and expand it, then arrow down to login and expand it; then arrow down to SA and get properties on this account. You can set the password in this dialog. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Barry Toner Sent: Monday, November 05, 2012 6:57 AM To: blind-sysadmins(a)lists.hodgsonfamily.org Subject: [Blind-sysadmins] SQL Server Hi folks, I've been tasked to setup a Helpdesk for our company. I'm going with nService, http://www.avensoft.com/ The DB uses SQL. Thing is I've no idea about SQL Servers. I've installed SQL Express by reading the nService RTM. OK, fine, it's installed, and according to the Management and Config it's running. The next few things I'm asked to do I'm confused about and can't find the options for this. Switch to SQL Server and Windows Authentication mode Enable the "sa" account and set a password Also I've no idea the name of the SQL Server to connect to it. Would this just be local or locahost? If it's any good I've IIS installed and running as well. Can someone please tell me how I do this so I can continue with the installation? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins

2 2

Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress
by Barry Toner 22 Nov '12

22 Nov '12

Andrew! We're in! OK. So let me get this straight. " localhost\WASPDBEXPRESS" is that the name of my server, but I can create different Databases in this Server? Cheers, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 22 November 2012 09:49 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi, In which case from Management Studio try connecting to the server using localhost\WASPDBEXPRESS as you have given it a custom instance name. Thanks. Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 22 November 2012 09:28 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi Andrew, This is "SQL Server Management Studio Express" When I expand "SQL Server 2005 Network Configuration (32bit) in the " SQL Server Configuration Manager, all I see is, "Protocols for WASPDBEXPRESS". Which is the Database for our Asset management". Cheers, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 17:54 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi, Which SQL version? You should see some database engine protocols in there as well. What options did you choose during the install? Andrew. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Barry Toner Sent: 21 November 2012 16:51 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, I've looked at the link. When I go into Config, network , there's just oen protocol listed. This is for a DB an asset management is using. According to the step-by-step I should see, "Protocols for SQLExpress option," This isn't here... Regards, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 16:20 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, Did you do any work in configuration manager? Look here: http://www.razorsql.com/docs/support_sqlserver_express.html Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins(a)lists.hodgsonfamily.org Subject: [Blind-sysadmins] Can't connect to new installation of SQL Express Hi folks, I'm back at this old chestnut. I've just installed SQL Express, but can't connect to the server. The Server is installed locally on my Win 7 box. When I launch SQL Management and am prompted for a server to connect to, I type ".\SQLEXPRESS" and get, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)" I need to connect to the server so I can change or enter a new password. Any thoughts? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins

2 2

Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress
by Barry Toner 22 Nov '12

22 Nov '12

Hi, I've tried changing the password for sa. When I go into Security, select Log-In, and enter the new password, click OK I'm getting an error saying, " Change password failed for Login 'sa'. (Microsoft.SqlServer.Express.Smo)" An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)" " Cannot alter the login 'sa', because it does not exist or you do not have permission. (Microsoft SQL Server, Error: 15151)" Cheers, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 22 November 2012 09:49 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi, In which case from Management Studio try connecting to the server using localhost\WASPDBEXPRESS as you have given it a custom instance name. Thanks. Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 22 November 2012 09:28 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi Andrew, This is "SQL Server Management Studio Express" When I expand "SQL Server 2005 Network Configuration (32bit) in the " SQL Server Configuration Manager, all I see is, "Protocols for WASPDBEXPRESS". Which is the Database for our Asset management". Cheers, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 17:54 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi, Which SQL version? You should see some database engine protocols in there as well. What options did you choose during the install? Andrew. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Barry Toner Sent: 21 November 2012 16:51 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, I've looked at the link. When I go into Config, network , there's just oen protocol listed. This is for a DB an asset management is using. According to the step-by-step I should see, "Protocols for SQLExpress option," This isn't here... Regards, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 16:20 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, Did you do any work in configuration manager? Look here: http://www.razorsql.com/docs/support_sqlserver_express.html Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins(a)lists.hodgsonfamily.org Subject: [Blind-sysadmins] Can't connect to new installation of SQL Express Hi folks, I'm back at this old chestnut. I've just installed SQL Express, but can't connect to the server. The Server is installed locally on my Win 7 box. When I launch SQL Management and am prompted for a server to connect to, I type ".\SQLEXPRESS" and get, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)" I need to connect to the server so I can change or enter a new password. Any thoughts? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins

2 2

Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress
by Barry Toner 22 Nov '12

22 Nov '12

Hi, I've tried changing the password for sa. When I go into Security, select Log-In, and enter the new password, click OK I'm getting an error saying, " Change password failed for Login 'sa'. (Microsoft.SqlServer.Express.Smo)" An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)" " Cannot alter the login 'sa', because it does not exist or you do not have permission. (Microsoft SQL Server, Error: 15151)" Cheers, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 22 November 2012 09:49 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi, In which case from Management Studio try connecting to the server using localhost\WASPDBEXPRESS as you have given it a custom instance name. Thanks. Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 22 November 2012 09:28 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi Andrew, This is "SQL Server Management Studio Express" When I expand "SQL Server 2005 Network Configuration (32bit) in the " SQL Server Configuration Manager, all I see is, "Protocols for WASPDBEXPRESS". Which is the Database for our Asset management". Cheers, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 17:54 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi, Which SQL version? You should see some database engine protocols in there as well. What options did you choose during the install? Andrew. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Barry Toner Sent: 21 November 2012 16:51 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, I've looked at the link. When I go into Config, network , there's just oen protocol listed. This is for a DB an asset management is using. According to the step-by-step I should see, "Protocols for SQLExpress option," This isn't here... Regards, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 16:20 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, Did you do any work in configuration manager? Look here: http://www.razorsql.com/docs/support_sqlserver_express.html Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins(a)lists.hodgsonfamily.org Subject: [Blind-sysadmins] Can't connect to new installation of SQL Express Hi folks, I'm back at this old chestnut. I've just installed SQL Express, but can't connect to the server. The Server is installed locally on my Win 7 box. When I launch SQL Management and am prompted for a server to connect to, I type ".\SQLEXPRESS" and get, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)" I need to connect to the server so I can change or enter a new password. Any thoughts? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins

1 0

Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress
by Barry Toner 22 Nov '12

22 Nov '12

Andrew! We're in! OK. So let me get this straight. " localhost\WASPDBEXPRESS" is that the name of my server, but I can create different Databases in this Server? Cheers, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 22 November 2012 09:49 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi, In which case from Management Studio try connecting to the server using localhost\WASPDBEXPRESS as you have given it a custom instance name. Thanks. Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 22 November 2012 09:28 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi Andrew, This is "SQL Server Management Studio Express" When I expand "SQL Server 2005 Network Configuration (32bit) in the " SQL Server Configuration Manager, all I see is, "Protocols for WASPDBEXPRESS". Which is the Database for our Asset management". Cheers, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 17:54 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi, Which SQL version? You should see some database engine protocols in there as well. What options did you choose during the install? Andrew. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Barry Toner Sent: 21 November 2012 16:51 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, I've looked at the link. When I go into Config, network , there's just oen protocol listed. This is for a DB an asset management is using. According to the step-by-step I should see, "Protocols for SQLExpress option," This isn't here... Regards, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 16:20 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, Did you do any work in configuration manager? Look here: http://www.razorsql.com/docs/support_sqlserver_express.html Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins(a)lists.hodgsonfamily.org Subject: [Blind-sysadmins] Can't connect to new installation of SQL Express Hi folks, I'm back at this old chestnut. I've just installed SQL Express, but can't connect to the server. The Server is installed locally on my Win 7 box. When I launch SQL Management and am prompted for a server to connect to, I type ".\SQLEXPRESS" and get, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)" I need to connect to the server so I can change or enter a new password. Any thoughts? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins

1 0

Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress
by Barry Toner 22 Nov '12

22 Nov '12

Hi Andrew, This is "SQL Server Management Studio Express" When I expand "SQL Server 2005 Network Configuration (32bit) in the " SQL Server Configuration Manager, all I see is, "Protocols for WASPDBEXPRESS". Which is the Database for our Asset management". Cheers, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 17:54 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi, Which SQL version? You should see some database engine protocols in there as well. What options did you choose during the install? Andrew. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Barry Toner Sent: 21 November 2012 16:51 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, I've looked at the link. When I go into Config, network , there's just oen protocol listed. This is for a DB an asset management is using. According to the step-by-step I should see, "Protocols for SQLExpress option," This isn't here... Regards, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 16:20 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, Did you do any work in configuration manager? Look here: http://www.razorsql.com/docs/support_sqlserver_express.html Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins(a)lists.hodgsonfamily.org Subject: [Blind-sysadmins] Can't connect to new installation of SQL Express Hi folks, I'm back at this old chestnut. I've just installed SQL Express, but can't connect to the server. The Server is installed locally on my Win 7 box. When I launch SQL Management and am prompted for a server to connect to, I type ".\SQLEXPRESS" and get, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)" I need to connect to the server so I can change or enter a new password. Any thoughts? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins

2 2

Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress
by Barry Toner 22 Nov '12

22 Nov '12

Hi Andrew, This is "SQL Server Management Studio Express" When I expand "SQL Server 2005 Network Configuration (32bit) in the " SQL Server Configuration Manager, all I see is, "Protocols for WASPDBEXPRESS". Which is the Database for our Asset management". Cheers, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 17:54 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress Hi, Which SQL version? You should see some database engine protocols in there as well. What options did you choose during the install? Andrew. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Barry Toner Sent: 21 November 2012 16:51 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, I've looked at the link. When I go into Config, network , there's just oen protocol listed. This is for a DB an asset management is using. According to the step-by-step I should see, "Protocols for SQLExpress option," This isn't here... Regards, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 16:20 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, Did you do any work in configuration manager? Look here: http://www.razorsql.com/docs/support_sqlserver_express.html Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins(a)lists.hodgsonfamily.org Subject: [Blind-sysadmins] Can't connect to new installation of SQL Express Hi folks, I'm back at this old chestnut. I've just installed SQL Express, but can't connect to the server. The Server is installed locally on my Win 7 box. When I launch SQL Management and am prompted for a server to connect to, I type ".\SQLEXPRESS" and get, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)" I need to connect to the server so I can change or enter a new password. Any thoughts? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins

1 0

Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress
by Barry Toner 21 Nov '12

21 Nov '12

Hi, I've looked at the link. When I go into Config, network , there's just oen protocol listed. This is for a DB an asset management is using. According to the step-by-step I should see, "Protocols for SQLExpress option," This isn't here... Regards, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 16:20 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, Did you do any work in configuration manager? Look here: http://www.razorsql.com/docs/support_sqlserver_express.html Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins(a)lists.hodgsonfamily.org Subject: [Blind-sysadmins] Can't connect to new installation of SQL Express Hi folks, I'm back at this old chestnut. I've just installed SQL Express, but can't connect to the server. The Server is installed locally on my Win 7 box. When I launch SQL Management and am prompted for a server to connect to, I type ".\SQLEXPRESS" and get, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)" I need to connect to the server so I can change or enter a new password. Any thoughts? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins

2 2

Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress
by Barry Toner 21 Nov '12

21 Nov '12

Hi, I've looked at the link. When I go into Config, network , there's just oen protocol listed. This is for a DB an asset management is using. According to the step-by-step I should see, "Protocols for SQLExpress option," This isn't here... Regards, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 16:20 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, Did you do any work in configuration manager? Look here: http://www.razorsql.com/docs/support_sqlserver_express.html Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins(a)lists.hodgsonfamily.org Subject: [Blind-sysadmins] Can't connect to new installation of SQL Express Hi folks, I'm back at this old chestnut. I've just installed SQL Express, but can't connect to the server. The Server is installed locally on my Win 7 box. When I launch SQL Management and am prompted for a server to connect to, I type ".\SQLEXPRESS" and get, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)" I need to connect to the server so I can change or enter a new password. Any thoughts? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins

1 0

Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress
by Barry Toner 21 Nov '12

21 Nov '12

Hi, I'll check that link out. Nope I've not been into config manager as of yet. Will report back after I've had a look at that link. Cheers, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Andrew Hodgson Sent: 21 November 2012 16:20 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installation of SQLExpress Hi, Did you do any work in configuration manager? Look here: http://www.razorsql.com/docs/support_sqlserver_express.html Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces(a)lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner(a)clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins(a)lists.hodgsonfamily.org Subject: [Blind-sysadmins] Can't connect to new installation of SQL Express Hi folks, I'm back at this old chestnut. I've just installed SQL Express, but can't connect to the server. The Server is installed locally on my Win 7 box. When I launch SQL Management and am prompted for a server to connect to, I type ".\SQLEXPRESS" and get, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)" I need to connect to the server so I can change or enter a new password. Any thoughts? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins

1 0