2005 Express Edition: telnet localhost 1433 fails

I don't understand why.
My SQL Server 2005 is called PC\SQLEXPRESS. I use PC\Robert (administrator)
account on Windows XP Professional. I use Windows Authentication. Remote
connections are switched on ("Using both TCP/IP and names pipes.")
Please help. Thank you.
/RAM/Is the SQL Browser Service enabled and started?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"R.A.M." <r_ahimsa_m@.poczta.onet.pl> wrote in message
news:ejboa5$60k$1@.news.onet.pl...
>I don't understand why.
> My SQL Server 2005 is called PC\SQLEXPRESS. I use PC\Robert
> (administrator) account on Windows XP Professional. I use Windows
> Authentication. Remote connections are switched on ("Using both TCP/IP and
> names pipes.")
> Please help. Thank you.
> /RAM/
>|||Starting Browser Service doesn't help.
How I can check if port number is correct?
Uytkownik "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> napisa w
wiadomoci news:unW4OXMCHHA.3380@.TK2MSFTNGP04.phx.gbl...
> Is the SQL Browser Service enabled and started?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "R.A.M." <r_ahimsa_m@.poczta.onet.pl> wrote in message
> news:ejboa5$60k$1@.news.onet.pl...
>|||The error,log will contain what port the services are opening.
netstat -abn will tell you who's listening currently
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"R.A.M." <r_ahimsa_m@.poczta.onet.pl> wrote in message
news:ejfpj8$1di$1@.news.onet.pl...
> Starting Browser Service doesn't help.
> How I can check if port number is correct?
> Uytkownik "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> napisa
w
> wiadomoci news:unW4OXMCHHA.3380@.TK2MSFTNGP04.phx.gbl...
>

2005 Express

It's time to learn more about 2005. To start, I can't find SQLagent anywhere
in my SQLExpress install. I see docs that say to look under managment in
MS's Object Explorer, but I don't see anything under there but the logs and
the Activity Monitor.
Nor do I see anything thing specific on the Microsoft download page. I
installed Install "Microsoft SQL Server 2005 Express Edition" and "SQL
Server Management Studio Express", but not advanced services.
JayThere is no SQL Server Agent in Express Edition.
For more information SQL Server 2005 Express Edition, you may want to see
the following document:
http://msdn2.microsoft.com/en-us/library/ms345154.aspx
--
Ekrem Önsoy
"Jay" <spam@.nospam.org> wrote in message
news:ePp0TNzDIHA.5208@.TK2MSFTNGP04.phx.gbl...
> It's time to learn more about 2005. To start, I can't find SQLagent
> anywhere in my SQLExpress install. I see docs that say to look under
> managment in MS's Object Explorer, but I don't see anything under there
> but the logs and the Activity Monitor.
> Nor do I see anything thing specific on the Microsoft download page. I
> installed Install "Microsoft SQL Server 2005 Express Edition" and "SQL
> Server Management Studio Express", but not advanced services.
> Jay
>|||"Jay" <spam@.nospam.org> wrote in message
news:ePp0TNzDIHA.5208@.TK2MSFTNGP04.phx.gbl...
> It's time to learn more about 2005. To start, I can't find SQLagent
> anywhere in my SQLExpress install. I see docs that say to look under
> managment in MS's Object Explorer, but I don't see anything under there
> but the logs and the Activity Monitor.
> Nor do I see anything thing specific on the Microsoft download page. I
> installed Install "Microsoft SQL Server 2005 Express Edition" and "SQL
> Server Management Studio Express", but not advanced services.
> Jay
>
Agent is not included with Express.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
--
David Portas|||Jay,
SQL Agent does not come with SQL Server Express. You can use the Windows
Scheduler and SQLCMD to run SQL Jobs according to schedule. And of course,
people are writing code to fill the hole. For $79 the following solution is
being offered: http://www.valesoftware.com/products-express-agent.php
RLF
"Jay" <spam@.nospam.org> wrote in message
news:ePp0TNzDIHA.5208@.TK2MSFTNGP04.phx.gbl...
> It's time to learn more about 2005. To start, I can't find SQLagent
> anywhere in my SQLExpress install. I see docs that say to look under
> managment in MS's Object Explorer, but I don't see anything under there
> but the logs and the Activity Monitor.
> Nor do I see anything thing specific on the Microsoft download page. I
> installed Install "Microsoft SQL Server 2005 Express Edition" and "SQL
> Server Management Studio Express", but not advanced services.
> Jay
>|||OK, this explains why I kept finding references and was going nuts trying to
figure out how to get/enable it.
I assume that in the full versions, it works pretty much just like it does
in 2000 EM?
I also assume that to see it in MS (connected to a 2005 instance), you have
to be a admin on that machine.
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:2D8BFE09-BCC2-46F2-BDB2-36E7EB1971DE@.microsoft.com...
> There is no SQL Server Agent in Express Edition.
> For more information SQL Server 2005 Express Edition, you may want to see
> the following document:
> http://msdn2.microsoft.com/en-us/library/ms345154.aspx
> --
> Ekrem Önsoy
>
>
> "Jay" <spam@.nospam.org> wrote in message
> news:ePp0TNzDIHA.5208@.TK2MSFTNGP04.phx.gbl...
>> It's time to learn more about 2005. To start, I can't find SQLagent
>> anywhere in my SQLExpress install. I see docs that say to look under
>> managment in MS's Object Explorer, but I don't see anything under there
>> but the logs and the Activity Monitor.
>> Nor do I see anything thing specific on the Microsoft download page. I
>> installed Install "Microsoft SQL Server 2005 Express Edition" and "SQL
>> Server Management Studio Express", but not advanced services.
>> Jay
>|||Jay,
You don't need to be an admin to see SQL Agent on a non-Express SQL Server
2005, but you do need some rights. You can look up msdb fixed database
roles:
SQLAgentUserRole
SQLAgentReaderRole
SQLAgentOperatorRole
Rights increase as you proceed down the list.
RLF
"Jay" <nospan@.nospam.org> wrote in message
news:%23wOohW0DIHA.4772@.TK2MSFTNGP02.phx.gbl...
> OK, this explains why I kept finding references and was going nuts trying
> to figure out how to get/enable it.
> I assume that in the full versions, it works pretty much just like it does
> in 2000 EM?
> I also assume that to see it in MS (connected to a 2005 instance), you
> have to be a admin on that machine.
>
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:2D8BFE09-BCC2-46F2-BDB2-36E7EB1971DE@.microsoft.com...
>> There is no SQL Server Agent in Express Edition.
>> For more information SQL Server 2005 Express Edition, you may want to see
>> the following document:
>> http://msdn2.microsoft.com/en-us/library/ms345154.aspx
>> --
>> Ekrem Önsoy
>>
>>
>> "Jay" <spam@.nospam.org> wrote in message
>> news:ePp0TNzDIHA.5208@.TK2MSFTNGP04.phx.gbl...
>> It's time to learn more about 2005. To start, I can't find SQLagent
>> anywhere in my SQLExpress install. I see docs that say to look under
>> managment in MS's Object Explorer, but I don't see anything under there
>> but the logs and the Activity Monitor.
>> Nor do I see anything thing specific on the Microsoft download page. I
>> installed Install "Microsoft SQL Server 2005 Express Edition" and "SQL
>> Server Management Studio Express", but not advanced services.
>> Jay
>>
>|||Thanks, Russell.
While what you say sounds reasonable, what I am seeing doesn't match.
I connected to our 2005 Standard Edition server using my rather limited
account and I do not see "Maintenance Plans" under the Managment tree.
However, when I checked it with the guy doing admin on that box, he does
have "Maintenance Plans" listed.
I supose this doesn't really matter, as I'll have full assess on that
machine shortly. What I don't (and need to know) is how to use it. I'm
hoping that it is a simple as 2000 SQLagent.
Jay
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:%23gu7y10DIHA.3332@.TK2MSFTNGP04.phx.gbl...
> Jay,
> You don't need to be an admin to see SQL Agent on a non-Express SQL Server
> 2005, but you do need some rights. You can look up msdb fixed database
> roles:
> SQLAgentUserRole
> SQLAgentReaderRole
> SQLAgentOperatorRole
> Rights increase as you proceed down the list.
> RLF
> "Jay" <nospan@.nospam.org> wrote in message
> news:%23wOohW0DIHA.4772@.TK2MSFTNGP02.phx.gbl...
>> OK, this explains why I kept finding references and was going nuts trying
>> to figure out how to get/enable it.
>> I assume that in the full versions, it works pretty much just like it
>> does in 2000 EM?
>> I also assume that to see it in MS (connected to a 2005 instance), you
>> have to be a admin on that machine.
>>
>> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
>> news:2D8BFE09-BCC2-46F2-BDB2-36E7EB1971DE@.microsoft.com...
>> There is no SQL Server Agent in Express Edition.
>> For more information SQL Server 2005 Express Edition, you may want to
>> see the following document:
>> http://msdn2.microsoft.com/en-us/library/ms345154.aspx
>> --
>> Ekrem Önsoy
>>
>>
>> "Jay" <spam@.nospam.org> wrote in message
>> news:ePp0TNzDIHA.5208@.TK2MSFTNGP04.phx.gbl...
>> It's time to learn more about 2005. To start, I can't find SQLagent
>> anywhere in my SQLExpress install. I see docs that say to look under
>> managment in MS's Object Explorer, but I don't see anything under there
>> but the logs and the Activity Monitor.
>> Nor do I see anything thing specific on the Microsoft download page. I
>> installed Install "Microsoft SQL Server 2005 Express Edition" and "SQL
>> Server Management Studio Express", but not advanced services.
>> Jay
>>
>>
>|||Hi Jay,
Today I realized that, if you do not have sysadmin server fixed role,
Maintanence Tasks node does not appear under Management in SSMS.
It's quite easy to use it. Don't worry.
Maybe the following link helps for a start.
http://msdn2.microsoft.com/en-us/library/ms189953.aspx
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Jay" <nospan@.nospam.org> wrote in message
news:%23Mpse$0DIHA.536@.TK2MSFTNGP06.phx.gbl...
> Thanks, Russell.
> While what you say sounds reasonable, what I am seeing doesn't match.
> I connected to our 2005 Standard Edition server using my rather limited
> account and I do not see "Maintenance Plans" under the Managment tree.
> However, when I checked it with the guy doing admin on that box, he does
> have "Maintenance Plans" listed.
> I supose this doesn't really matter, as I'll have full assess on that
> machine shortly. What I don't (and need to know) is how to use it. I'm
> hoping that it is a simple as 2000 SQLagent.
> Jay
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:%23gu7y10DIHA.3332@.TK2MSFTNGP04.phx.gbl...
>> Jay,
>> You don't need to be an admin to see SQL Agent on a non-Express SQL
>> Server 2005, but you do need some rights. You can look up msdb fixed
>> database roles:
>> SQLAgentUserRole
>> SQLAgentReaderRole
>> SQLAgentOperatorRole
>> Rights increase as you proceed down the list.
>> RLF
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:%23wOohW0DIHA.4772@.TK2MSFTNGP02.phx.gbl...
>> OK, this explains why I kept finding references and was going nuts
>> trying to figure out how to get/enable it.
>> I assume that in the full versions, it works pretty much just like it
>> does in 2000 EM?
>> I also assume that to see it in MS (connected to a 2005 instance), you
>> have to be a admin on that machine.
>>
>> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
>> news:2D8BFE09-BCC2-46F2-BDB2-36E7EB1971DE@.microsoft.com...
>> There is no SQL Server Agent in Express Edition.
>> For more information SQL Server 2005 Express Edition, you may want to
>> see the following document:
>> http://msdn2.microsoft.com/en-us/library/ms345154.aspx
>> --
>> Ekrem Önsoy
>>
>>
>> "Jay" <spam@.nospam.org> wrote in message
>> news:ePp0TNzDIHA.5208@.TK2MSFTNGP04.phx.gbl...
>> It's time to learn more about 2005. To start, I can't find SQLagent
>> anywhere in my SQLExpress install. I see docs that say to look under
>> managment in MS's Object Explorer, but I don't see anything under
>> there but the logs and the Activity Monitor.
>> Nor do I see anything thing specific on the Microsoft download page. I
>> installed Install "Microsoft SQL Server 2005 Express Edition" and "SQL
>> Server Management Studio Express", but not advanced services.
>> Jay
>>
>>
>>
>

2005 Create new instance, replace sqlexpress

I had installed Sql Express on my machine, now i have Visual Studio Pro
2005 which came with Sql Server 2005 Developer edition. I carefully
uninstalled anything I could find that was related to the express
edition before installing Developer. But still when I try to connect in
Management studio, it gives me only my Sql 2000 instance or a 2005
instance name SqlExpress. It fails trying to connect to the 2005
instance because apparently Express can't be connected to with this
tool.
Do I need to add a new instance? How do I get rid of the old one and
install a new one?
Any guidance appreciated, coming up with nothing in Books online and
this ng.
Bob(rvgrahamsevatenein@.sbcglobal.net) writes:
> I had installed Sql Express on my machine, now i have Visual Studio Pro
> 2005 which came with Sql Server 2005 Developer edition. I carefully
> uninstalled anything I could find that was related to the express
> edition before installing Developer. But still when I try to connect in
> Management studio, it gives me only my Sql 2000 instance or a 2005
> instance name SqlExpress. It fails trying to connect to the 2005
> instance because apparently Express can't be connected to with this
> tool.
> Do I need to add a new instance? How do I get rid of the old one and
> install a new one?
> Any guidance appreciated, coming up with nothing in Books online and
> this ng.
How did you run the install of Developer edition? Did you require a
named instance, or did you select a default instance? If you selected
the default instance, and you had SQL 2000 installed as a default instance,
then that install would have been upgraded to SQL 2005. Have you connected
to the instance check what @.@.version says?
Note that for an upgrage of SQL 2000 to succed you need at least SP3 of
SQL 2000.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi
Uninstall SQL Server Express Edition with all related installation (See in
ADD\REMOVE Program)
Moreover if you have a network (I have encountered some problems when it got
to set security File Stat )
, I'd suggest to unplug a cable and run SETUP
<rvgrahamsevatenein@.sbcglobal.net> wrote in message
news:1138996401.832192.216900@.z14g2000cwz.googlegroups.com...
>I had installed Sql Express on my machine, now i have Visual Studio Pro
> 2005 which came with Sql Server 2005 Developer edition. I carefully
> uninstalled anything I could find that was related to the express
> edition before installing Developer. But still when I try to connect in
> Management studio, it gives me only my Sql 2000 instance or a 2005
> instance name SqlExpress. It fails trying to connect to the 2005
> instance because apparently Express can't be connected to with this
> tool.
> Do I need to add a new instance? How do I get rid of the old one and
> install a new one?
> Any guidance appreciated, coming up with nothing in Books online and
> this ng.
> Bob
>|||Thank you for your replies,
I discovered when I did this same install on my home development
machine that what I had done wrong was to not specify for the Developer
Edition install to create a new named instance.
I was also unaware that VS2005 setup also installs SqlExpress, and that
it's apparently intentional that you end up with both running on your
machine. I'm assuming this is so you have Express available for testing
and deploying client apps containing stand-alone SqlExpress instances?
Bob Graham