Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress
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@lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner@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@lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner@clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins@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@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins
Hi, WASPDBEXPRESS is the instance name. The instance is a database server. You can create databases in this instance. You can have many instances per machine (though most people don't do this). Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces@lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner@clanmil.org.uk] Sent: 22 November 2012 09:57 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress 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@lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner@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@lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner@clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins@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@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins
Hi, WASPDBEXPRESS is the instance name. The instance is a database server. You can create databases in this instance. You can have many instances per machine (though most people don't do this). Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces@lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner@clanmil.org.uk] Sent: 22 November 2012 09:57 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] Can't connect to new installationof SQLExpress 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@lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner@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@lists.hodgsonfamily.org] on behalf of Barry Toner [Barry.Toner@clanmil.org.uk] Sent: 21 November 2012 15:32 To: blind-sysadmins@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@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins
participants (2)
-
Andrew Hodgson -
Barry Toner