HOME USER AND SQL

I am a simple home user, I do not develop nor do I extract information for
analysis or whatever - do I still need SQL? Can I just remove SQL?
On Sat, 4 Aug 2007 02:54:01 -0700, Denis Arial wrote:

>I am a simple home user, I do not develop nor do I extract information for
>analysis or whatever - do I still need SQL? Can I just remove SQL?
Hi Denis,
If you installed it yourself to have a look and decided not to pursue it
any further, it's probably safe to uninstall. However, if SQL was
installed as part of another program, that other program probably uses
it, and might sstop working if you decide to uninstall SQL Server.
What you can do is stop the SQL Server service (if it is currently
active) and change the startup settings to not start on system startup.
That way, programs using SQL Server will either fail, or (if they are
able to) start the service themselves. The former is very easy to
notice; the second can also be noted if you regularly check what
services are running.
Use the PC for some time, making sure to use all your relevant programs
(including those you use only once a month, and make sure to use all
functions in a program you typically need). If you got no errors and the
SQL Server service was not started, it's safe to assume that none of
your programs uses it, so you can proceed to uninstall.
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Home page has no tabs

Using System Role Assignment I grant a domain user account "System Administrator" & "System User" within Reporting Services.

Then I connect via IE7 to Report Server with the domain account that has been granted the above rights. The page comes up but the "Contents" and "Properties" tabs are missing. This user can use "Site Settings" and perform admin though.

If I assign the users domain account to the local Administrator group on the Win 2003 Server, then when they reconnect to Reporting Services the missing tabs appear.

We are a development shop, need some of our qa testers and developers to have admin rights within Reporting Services but don't want to grant them local Administrator rights on the server. This could also be an issue upon deployment at customer sites.

So how to get round this. I have been trying ACL's on the Reporting Services directorys, ASP.Net security etc but with no success.

PS: Everything was sweet before SP2

OK found the answer. Use "MS SQL Server Management Studio" and connect to the Reporting Services instance.

Then on "Home" right mouse and select properties. Under permissions you have to add the windows users that are to have access.

So domain\uid, and tick the box's for the access that person needs.

Home page blank.

When i try to administer my Reporting Services, the following page
comes up with the picture of a folder and "Home"
http://dev7/Reports/Pages/Folder.aspx
How do I administer the Reporting Services enough to at least give
myself permissions to administer it?Browse to the server as a local administrator. Local admins have privileges
to set the security on items.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Trevor Morris" <StopTrevor@.gmail.com> wrote in message
news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> When i try to administer my Reporting Services, the following page
> comes up with the picture of a folder and "Home"
> http://dev7/Reports/Pages/Folder.aspx
> How do I administer the Reporting Services enough to at least give
> myself permissions to administer it?|||I've browsed there as local admin and domain admin. Neither user has
anything on the Reports home page.
"Daniel Reib (MSFT)" wrote:
> Browse to the server as a local administrator. Local admins have privileges
> to set the security on items.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> > When i try to administer my Reporting Services, the following page
> > comes up with the picture of a folder and "Home"
> > http://dev7/Reports/Pages/Folder.aspx
> >
> > How do I administer the Reporting Services enough to at least give
> > myself permissions to administer it?
>
>|||Usually this is because you have set your web site to anonymous. RS then
treats everybody as the same user which means no matter how you access it
you have only browse rights.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trevor Morris" <StopTrevor@.gmail.com> wrote in message
news:C4E963BF-836E-46EE-98D4-681C695B5F64@.microsoft.com...
> I've browsed there as local admin and domain admin. Neither user has
> anything on the Reports home page.
> "Daniel Reib (MSFT)" wrote:
> > Browse to the server as a local administrator. Local admins have
privileges
> > to set the security on items.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> > > When i try to administer my Reporting Services, the following page
> > > comes up with the picture of a folder and "Home"
> > > http://dev7/Reports/Pages/Folder.aspx
> > >
> > > How do I administer the Reporting Services enough to at least give
> > > myself permissions to administer it?
> >
> >
> >|||Good guess, but still no luck.
The Reports directory does not have anonymous access enabled.
"Bruce L-C [MVP]" wrote:
> Usually this is because you have set your web site to anonymous. RS then
> treats everybody as the same user which means no matter how you access it
> you have only browse rights.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> news:C4E963BF-836E-46EE-98D4-681C695B5F64@.microsoft.com...
> > I've browsed there as local admin and domain admin. Neither user has
> > anything on the Reports home page.
> >
> > "Daniel Reib (MSFT)" wrote:
> >
> > > Browse to the server as a local administrator. Local admins have
> privileges
> > > to set the security on items.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > > news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> > > > When i try to administer my Reporting Services, the following page
> > > > comes up with the picture of a folder and "Home"
> > > > http://dev7/Reports/Pages/Folder.aspx
> > > >
> > > > How do I administer the Reporting Services enough to at least give
> > > > myself permissions to administer it?
> > >
> > >
> > >
>
>|||Check both Reports and ReportServer in IIS Manager and make sure that
neither one has anonymous access enabled.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trevor Morris" <StopTrevor@.gmail.com> wrote in message
news:EE02F092-41F6-47E6-B8E0-F60794E9B1AA@.microsoft.com...
> Good guess, but still no luck.
> The Reports directory does not have anonymous access enabled.
> "Bruce L-C [MVP]" wrote:
> > Usually this is because you have set your web site to anonymous. RS then
> > treats everybody as the same user which means no matter how you access
it
> > you have only browse rights.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > news:C4E963BF-836E-46EE-98D4-681C695B5F64@.microsoft.com...
> > > I've browsed there as local admin and domain admin. Neither user has
> > > anything on the Reports home page.
> > >
> > > "Daniel Reib (MSFT)" wrote:
> > >
> > > > Browse to the server as a local administrator. Local admins have
> > privileges
> > > > to set the security on items.
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > > > news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> > > > > When i try to administer my Reporting Services, the following page
> > > > > comes up with the picture of a folder and "Home"
> > > > > http://dev7/Reports/Pages/Folder.aspx
> > > > >
> > > > > How do I administer the Reporting Services enough to at least give
> > > > > myself permissions to administer it?
> > > >
> > > >
> > > >
> >
> >
> >|||OK. That did it.
Now, how do I enable anonymous access to reports, but require (or even
allow!) administration of the site? I'm very surprised that these two are
linked! Thanks for the help.
"Bruce L-C [MVP]" wrote:
> Check both Reports and ReportServer in IIS Manager and make sure that
> neither one has anonymous access enabled.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> news:EE02F092-41F6-47E6-B8E0-F60794E9B1AA@.microsoft.com...
> > Good guess, but still no luck.
> > The Reports directory does not have anonymous access enabled.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Usually this is because you have set your web site to anonymous. RS then
> > > treats everybody as the same user which means no matter how you access
> it
> > > you have only browse rights.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > > news:C4E963BF-836E-46EE-98D4-681C695B5F64@.microsoft.com...
> > > > I've browsed there as local admin and domain admin. Neither user has
> > > > anything on the Reports home page.
> > > >
> > > > "Daniel Reib (MSFT)" wrote:
> > > >
> > > > > Browse to the server as a local administrator. Local admins have
> > > privileges
> > > > > to set the security on items.
> > > > >
> > > > > --
> > > > > -Daniel
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > >
> > > > >
> > > > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > > > > news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> > > > > > When i try to administer my Reporting Services, the following page
> > > > > > comes up with the picture of a folder and "Home"
> > > > > > http://dev7/Reports/Pages/Folder.aspx
> > > > > >
> > > > > > How do I administer the Reporting Services enough to at least give
> > > > > > myself permissions to administer it?
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||You can't have it both ways. You can't say anyone can access it but only
certain people can do certain functions. If they are anonymous then how can
you know who they are. Is there an intranet or extranet application. If
intranet there is an easy solution, extranet is a different matter.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trevor Morris" <StopTrevor@.gmail.com> wrote in message
news:71ECABEE-229A-49CA-9030-1289F35930CF@.microsoft.com...
> OK. That did it.
> Now, how do I enable anonymous access to reports, but require (or even
> allow!) administration of the site? I'm very surprised that these two are
> linked! Thanks for the help.
> "Bruce L-C [MVP]" wrote:
>> Check both Reports and ReportServer in IIS Manager and make sure that
>> neither one has anonymous access enabled.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
>> news:EE02F092-41F6-47E6-B8E0-F60794E9B1AA@.microsoft.com...
>> > Good guess, but still no luck.
>> > The Reports directory does not have anonymous access enabled.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> > > Usually this is because you have set your web site to anonymous. RS
>> > > then
>> > > treats everybody as the same user which means no matter how you
>> > > access
>> it
>> > > you have only browse rights.
>> > >
>> > >
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > >
>> > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
>> > > news:C4E963BF-836E-46EE-98D4-681C695B5F64@.microsoft.com...
>> > > > I've browsed there as local admin and domain admin. Neither user
>> > > > has
>> > > > anything on the Reports home page.
>> > > >
>> > > > "Daniel Reib (MSFT)" wrote:
>> > > >
>> > > > > Browse to the server as a local administrator. Local admins have
>> > > privileges
>> > > > > to set the security on items.
>> > > > >
>> > > > > --
>> > > > > -Daniel
>> > > > > This posting is provided "AS IS" with no warranties, and confers
>> > > > > no
>> > > rights.
>> > > > >
>> > > > >
>> > > > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
>> > > > > news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
>> > > > > > When i try to administer my Reporting Services, the following
>> > > > > > page
>> > > > > > comes up with the picture of a folder and "Home"
>> > > > > > http://dev7/Reports/Pages/Folder.aspx
>> > > > > >
>> > > > > > How do I administer the Reporting Services enough to at least
>> > > > > > give
>> > > > > > myself permissions to administer it?
>> > > > >
>> > > > >
>> > > > >
>> > >
>> > >
>> > >
>>

Home page access

We are running the June CTP.
When some users go to htttp://theserver/Reports, all they see is the
word 'Home' and a line across the page.
This happens even though I have added these users as both
Administrators and Users.
I imagine that this has something to do with the domain, but I don't
see what arrangement would allow them to get to a partially completed
page.
Any ideas?
JimMake sure the RS services are running under a domain log in and that the
login has permissions on the Tempfiles directory under ths MSSQL.3
directory.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<jhcorey@.yahoo.com> wrote in message
news:1125062702.187423.141040@.g14g2000cwa.googlegroups.com...
> We are running the June CTP.
> When some users go to htttp://theserver/Reports, all they see is the
> word 'Home' and a line across the page.
> This happens even though I have added these users as both
> Administrators and Users.
> I imagine that this has something to do with the domain, but I don't
> see what arrangement would allow them to get to a partially completed
> page.
> Any ideas?
> Jim
>|||The services are running under a login that is an admin in the domain,
as well as an admin on the machine.
We notice that there is a user group on the machine called.
SQLServer2005ReportServerUser$MSSQLServer. Users that we've added to
this can use RS normally. But as I noted, users that we've added from
the web site cannot. These are all users in the same domain.|||My guess here is that they have not been setup in a role. The windows groups
are for validation of who they are, not what they can do. You need to assign
users or groups to a role (in report manager). Read up in books online about
roles. What I do is have a local group to that local group I add domain
groups and invidual users. I then assign the local group to the browser
role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<jhcorey@.yahoo.com> wrote in message
news:1125330865.896229.33860@.f14g2000cwb.googlegroups.com...
> The services are running under a login that is an admin in the domain,
> as well as an admin on the machine.
> We notice that there is a user group on the machine called.
> SQLServer2005ReportServerUser$MSSQLServer. Users that we've added to
> this can use RS normally. But as I noted, users that we've added from
> the web site cannot. These are all users in the same domain.
>|||Ah yes, it was simple of course once one knew where to look -- in the
properties for the home page.
I was thinking that System security would take care of everything.

Home Network w/ 2 SQLServers: 1-way problem

I have a WinXP Pro home network which is behind a firewall. Within
this network I have 2 computers running SQLServer 2000: my desktop and
my laptop. Both instances are configured identically and use Windows
authentication. I use Enterprise Manager.
- My laptop can "see" the desktop's instance; i.e., I'm able to create
a SQLServer Registration entry and browse the desktop's databases
- My desktop can NOT "see" the laptop's instance. When I try to create
a SQLServer Registration, I receive "SQL Server does not exist or
access denied..."
I've tried registering via the laptop's computer name, and I've tried
registering via the laptop's local IP address.
My firewall is not allowing access to port 1433 for either computer.
Both computers can see each other through file/printer sharing.
SQLServer seems to be the only case where there is a "blockage".
Any help is appreciated...
-JeffOne other note -- both machines can ping each other by IP and by name.
Jeff wrote:
> I have a WinXP Pro home network which is behind a firewall. Within
> this network I have 2 computers running SQLServer 2000: my desktop
and
> my laptop. Both instances are configured identically and use Windows
> authentication. I use Enterprise Manager.
> - My laptop can "see" the desktop's instance; i.e., I'm able to
create
> a SQLServer Registration entry and browse the desktop's databases
> - My desktop can NOT "see" the laptop's instance. When I try to
create
> a SQLServer Registration, I receive "SQL Server does not exist or
> access denied..."
> I've tried registering via the laptop's computer name, and I've tried
> registering via the laptop's local IP address.
> My firewall is not allowing access to port 1433 for either computer.
> Both computers can see each other through file/printer sharing.
> SQLServer seems to be the only case where there is a "blockage".
> Any help is appreciated...
> -Jeff|||Jeff wrote:
> I have a WinXP Pro home network which is behind a firewall. Within
> this network I have 2 computers running SQLServer 2000: my desktop
> and my laptop. Both instances are configured identically and use
> Windows authentication. I use Enterprise Manager.
>
If you're blocking 1433 on both PCs, how are you connecting to the
desktop from the laptop? Named Pipes? Try using the same network
protocol to connect the other way around.
David Gugick
Imceda Software
www.imceda.com|||Would the firewall blockage apply internally? I thought the firewall
would only prevent outside access? In other words, I didn't think that
my firewall would prevent internal machines from communicating?
Anyhow, both Named Pipes and TCP/IP are enabled.
The Server Network Utility and Client Network Utility settings are
identical on both machines.

> If you're blocking 1433 on both PCs, how are you connecting to the
> desktop from the laptop? Named Pipes? Try using the same network
> protocol to connect the other way around.
> --
> David Gugick
> Imceda Software
> www.imceda.com|||Jeff wrote:
> Would the firewall blockage apply internally? I thought the firewall
> would only prevent outside access? In other words, I didn't think
> that my firewall would prevent internal machines from communicating?
> Anyhow, both Named Pipes and TCP/IP are enabled.
> The Server Network Utility and Client Network Utility settings are
> identical on both machines.
Turn off any firewalls and see what happens.
David Gugick
Imceda Software
www.imceda.com|||Is your Firewall also acting as your LAN router? If so, it is probably
blocking your internal traffic as well. Consider putting your Firewall in
front of a real LAN router, that's how it is usually configured. If so,
then that configuration would behave as you suspect, blocking only traffic
onto/out of the router, but not packets routed between back end hosts.
Sincerely,
Anthony Thomas
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23mN$uleHFHA.3196@.TK2MSFTNGP15.phx.gbl...
Jeff wrote:
> Would the firewall blockage apply internally? I thought the firewall
> would only prevent outside access? In other words, I didn't think
> that my firewall would prevent internal machines from communicating?
> Anyhow, both Named Pipes and TCP/IP are enabled.
> The Server Network Utility and Client Network Utility settings are
> identical on both machines.
Turn off any firewalls and see what happens.
David Gugick
Imceda Software
www.imceda.comsql

Home Network w/ 2 SQLServers: 1-way problem

I have a WinXP Pro home network which is behind a firewall. Within
this network I have 2 computers running SQLServer 2000: my desktop and
my laptop. Both instances are configured identically and use Windows
authentication. I use Enterprise Manager.
- My laptop can "see" the desktop's instance; i.e., I'm able to create
a SQLServer Registration entry and browse the desktop's databases
- My desktop can NOT "see" the laptop's instance. When I try to create
a SQLServer Registration, I receive "SQL Server does not exist or
access denied..."
I've tried registering via the laptop's computer name, and I've tried
registering via the laptop's local IP address.
My firewall is not allowing access to port 1433 for either computer.
Both computers can see each other through file/printer sharing.
SQLServer seems to be the only case where there is a "blockage".
Any help is appreciated...
-Jeff
One other note -- both machines can ping each other by IP and by name.
Jeff wrote:
> I have a WinXP Pro home network which is behind a firewall. Within
> this network I have 2 computers running SQLServer 2000: my desktop
and
> my laptop. Both instances are configured identically and use Windows
> authentication. I use Enterprise Manager.
> - My laptop can "see" the desktop's instance; i.e., I'm able to
create
> a SQLServer Registration entry and browse the desktop's databases
> - My desktop can NOT "see" the laptop's instance. When I try to
create
> a SQLServer Registration, I receive "SQL Server does not exist or
> access denied..."
> I've tried registering via the laptop's computer name, and I've tried
> registering via the laptop's local IP address.
> My firewall is not allowing access to port 1433 for either computer.
> Both computers can see each other through file/printer sharing.
> SQLServer seems to be the only case where there is a "blockage".
> Any help is appreciated...
> -Jeff
|||Jeff wrote:
> I have a WinXP Pro home network which is behind a firewall. Within
> this network I have 2 computers running SQLServer 2000: my desktop
> and my laptop. Both instances are configured identically and use
> Windows authentication. I use Enterprise Manager.
>
If you're blocking 1433 on both PCs, how are you connecting to the
desktop from the laptop? Named Pipes? Try using the same network
protocol to connect the other way around.
David Gugick
Imceda Software
www.imceda.com
|||Would the firewall blockage apply internally? I thought the firewall
would only prevent outside access? In other words, I didn't think that
my firewall would prevent internal machines from communicating?
Anyhow, both Named Pipes and TCP/IP are enabled.
The Server Network Utility and Client Network Utility settings are
identical on both machines.

> If you're blocking 1433 on both PCs, how are you connecting to the
> desktop from the laptop? Named Pipes? Try using the same network
> protocol to connect the other way around.
> --
> David Gugick
> Imceda Software
> www.imceda.com
|||Jeff wrote:
> Would the firewall blockage apply internally? I thought the firewall
> would only prevent outside access? In other words, I didn't think
> that my firewall would prevent internal machines from communicating?
> Anyhow, both Named Pipes and TCP/IP are enabled.
> The Server Network Utility and Client Network Utility settings are
> identical on both machines.
Turn off any firewalls and see what happens.
David Gugick
Imceda Software
www.imceda.com
|||Is your Firewall also acting as your LAN router? If so, it is probably
blocking your internal traffic as well. Consider putting your Firewall in
front of a real LAN router, that's how it is usually configured. If so,
then that configuration would behave as you suspect, blocking only traffic
onto/out of the router, but not packets routed between back end hosts.
Sincerely,
Anthony Thomas

"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23mN$uleHFHA.3196@.TK2MSFTNGP15.phx.gbl...
Jeff wrote:
> Would the firewall blockage apply internally? I thought the firewall
> would only prevent outside access? In other words, I didn't think
> that my firewall would prevent internal machines from communicating?
> Anyhow, both Named Pipes and TCP/IP are enabled.
> The Server Network Utility and Client Network Utility settings are
> identical on both machines.
Turn off any firewalls and see what happens.
David Gugick
Imceda Software
www.imceda.com

Home Network w/ 2 SQLServers: 1-way problem

I have a WinXP Pro home network which is behind a firewall. Within
this network I have 2 computers running SQLServer 2000: my desktop and
my laptop. Both instances are configured identically and use Windows
authentication. I use Enterprise Manager.
- My laptop can "see" the desktop's instance; i.e., I'm able to create
a SQLServer Registration entry and browse the desktop's databases
- My desktop can NOT "see" the laptop's instance. When I try to create
a SQLServer Registration, I receive "SQL Server does not exist or
access denied..."
I've tried registering via the laptop's computer name, and I've tried
registering via the laptop's local IP address.
My firewall is not allowing access to port 1433 for either computer.
Both computers can see each other through file/printer sharing.
SQLServer seems to be the only case where there is a "blockage".
Any help is appreciated...
-JeffOne other note -- both machines can ping each other by IP and by name.
Jeff wrote:
> I have a WinXP Pro home network which is behind a firewall. Within
> this network I have 2 computers running SQLServer 2000: my desktop
and
> my laptop. Both instances are configured identically and use Windows
> authentication. I use Enterprise Manager.
> - My laptop can "see" the desktop's instance; i.e., I'm able to
create
> a SQLServer Registration entry and browse the desktop's databases
> - My desktop can NOT "see" the laptop's instance. When I try to
create
> a SQLServer Registration, I receive "SQL Server does not exist or
> access denied..."
> I've tried registering via the laptop's computer name, and I've tried
> registering via the laptop's local IP address.
> My firewall is not allowing access to port 1433 for either computer.
> Both computers can see each other through file/printer sharing.
> SQLServer seems to be the only case where there is a "blockage".
> Any help is appreciated...
> -Jeff|||Jeff wrote:
> I have a WinXP Pro home network which is behind a firewall. Within
> this network I have 2 computers running SQLServer 2000: my desktop
> and my laptop. Both instances are configured identically and use
> Windows authentication. I use Enterprise Manager.
>
If you're blocking 1433 on both PCs, how are you connecting to the
desktop from the laptop? Named Pipes? Try using the same network
protocol to connect the other way around.
--
David Gugick
Imceda Software
www.imceda.com|||Would the firewall blockage apply internally? I thought the firewall
would only prevent outside access? In other words, I didn't think that
my firewall would prevent internal machines from communicating?
Anyhow, both Named Pipes and TCP/IP are enabled.
The Server Network Utility and Client Network Utility settings are
identical on both machines.
> If you're blocking 1433 on both PCs, how are you connecting to the
> desktop from the laptop? Named Pipes? Try using the same network
> protocol to connect the other way around.
> --
> David Gugick
> Imceda Software
> www.imceda.com|||Jeff wrote:
> Would the firewall blockage apply internally? I thought the firewall
> would only prevent outside access? In other words, I didn't think
> that my firewall would prevent internal machines from communicating?
> Anyhow, both Named Pipes and TCP/IP are enabled.
> The Server Network Utility and Client Network Utility settings are
> identical on both machines.
Turn off any firewalls and see what happens.
--
David Gugick
Imceda Software
www.imceda.com|||Is your Firewall also acting as your LAN router? If so, it is probably
blocking your internal traffic as well. Consider putting your Firewall in
front of a real LAN router, that's how it is usually configured. If so,
then that configuration would behave as you suspect, blocking only traffic
onto/out of the router, but not packets routed between back end hosts.
Sincerely,
Anthony Thomas
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23mN$uleHFHA.3196@.TK2MSFTNGP15.phx.gbl...
Jeff wrote:
> Would the firewall blockage apply internally? I thought the firewall
> would only prevent outside access? In other words, I didn't think
> that my firewall would prevent internal machines from communicating?
> Anyhow, both Named Pipes and TCP/IP are enabled.
> The Server Network Utility and Client Network Utility settings are
> identical on both machines.
Turn off any firewalls and see what happens.
--
David Gugick
Imceda Software
www.imceda.com

home made corruption checker

I want to have my own DBCC tool. The problem I have with the Maintenance Pla
n
DBCC is I only want to be emailed when I have corruption. Not every day for
every DB. I wrote a proc, but what Im finding is that @.@.error still returns
a
0 even if there are certain types of corruption, so my proc is flawed. Does
anyone have another idea how I can accomplish my goals?
alter procedure admin_DBCCCheckDB
as
declare @.DBName varchar(128)
declare @.Exec varchar(128)
declare @.RC int
declare @.Error int
declare @.Subject varchar(128)
declare @.Server varchar(128)
declare @.Recipient varchar(128)
set @.Server = @.@.ServerName
set @.DBName = (select DB_Name())
set @.Exec = 'dbcc checkdb(''' + @.DBName + ''')' + 'WITH NO_INFOMSGS'
set @.Subject = 'Corruption in ' + @.DBName + '.!!!'
set @.Recipient = ''
exec (@.exec)
select @.Error = @.@.error
if @.Error <> 0
exec @.RC = master.dbo.xp_smtp_sendmail
@.FROM = @.Server
,@.TO = @.Recipient
,@.Subject = @.Subject
,@.server = N'smtpmail.azdes.gov'
,@.Port = 25
TIA,
ChrisRChris,
DBCC CHECKDB is not a stored procedure and I don't think using the @.@.ERROR
global variable is what you're looking for. For this just create a new job
to execute the DBCC CHECKDB statement for a given database with the
instructions to email you on failure and schedule the job.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:CCA21D09-B8B2-40BB-BD1F-CB9C04732EAA@.microsoft.com...
>I want to have my own DBCC tool. The problem I have with the Maintenance
>Plan
> DBCC is I only want to be emailed when I have corruption. Not every day
> for
> every DB. I wrote a proc, but what Im finding is that @.@.error still
> returns a
> 0 even if there are certain types of corruption, so my proc is flawed.
> Does
> anyone have another idea how I can accomplish my goals?
> alter procedure admin_DBCCCheckDB
> as
> declare @.DBName varchar(128)
> declare @.Exec varchar(128)
> declare @.RC int
> declare @.Error int
> declare @.Subject varchar(128)
> declare @.Server varchar(128)
> declare @.Recipient varchar(128)
> set @.Server = @.@.ServerName
> set @.DBName = (select DB_Name())
> set @.Exec = 'dbcc checkdb(''' + @.DBName + ''')' + 'WITH NO_INFOMSGS'
> set @.Subject = 'Corruption in ' + @.DBName + '.!!!'
> set @.Recipient = ''
> exec (@.exec)
> select @.Error = @.@.error
> if @.Error <> 0
> exec @.RC = master.dbo.xp_smtp_sendmail
> @.FROM = @.Server
> ,@.TO = @.Recipient
> ,@.Subject = @.Subject
> ,@.server = N'smtpmail.azdes.gov'
> ,@.Port = 25
> --
> TIA,
> ChrisR|||No need to use dynamic SQL for this. CHECKDB accepts a variable, so you can
catch the error after
and do additional steps if you need to. But it is easy enough to have Agent
just act On Success/On
Error also. It is up to you, what makes more sense and easier for you. Here'
s the script I ran
against a bad database to test it:
DECLARE @.db sysname, @.err int
SET @.db = 'badpubs'
DBCC CHECKDB(@.db) WITH NO_INFOMSGS
SET @.err = @.@.ERROR
IF @.err <> 0
SELECT 'Ouch, we have a problem', @.err
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:CCA21D09-B8B2-40BB-BD1F-CB9C04732EAA@.microsoft.com...
>I want to have my own DBCC tool. The problem I have with the Maintenance Pl
an
> DBCC is I only want to be emailed when I have corruption. Not every day fo
r
> every DB. I wrote a proc, but what Im finding is that @.@.error still return
s a
> 0 even if there are certain types of corruption, so my proc is flawed. Doe
s
> anyone have another idea how I can accomplish my goals?
> alter procedure admin_DBCCCheckDB
> as
> declare @.DBName varchar(128)
> declare @.Exec varchar(128)
> declare @.RC int
> declare @.Error int
> declare @.Subject varchar(128)
> declare @.Server varchar(128)
> declare @.Recipient varchar(128)
> set @.Server = @.@.ServerName
> set @.DBName = (select DB_Name())
> set @.Exec = 'dbcc checkdb(''' + @.DBName + ''')' + 'WITH NO_INFOMSGS'
> set @.Subject = 'Corruption in ' + @.DBName + '.!!!'
> set @.Recipient = ''
> exec (@.exec)
> select @.Error = @.@.error
> if @.Error <> 0
> exec @.RC = master.dbo.xp_smtp_sendmail
> @.FROM = @.Server
> ,@.TO = @.Recipient
> ,@.Subject = @.Subject
> ,@.server = N'smtpmail.azdes.gov'
> ,@.Port = 25
> --
> TIA,
> ChrisR

home made corruption checker

I want to have my own DBCC tool. The problem I have with the Maintenance Plan
DBCC is I only want to be emailed when I have corruption. Not every day for
every DB. I wrote a proc, but what Im finding is that @.@.error still returns a
0 even if there are certain types of corruption, so my proc is flawed. Does
anyone have another idea how I can accomplish my goals?
alter procedure admin_DBCCCheckDB
as
declare @.DBName varchar(128)
declare @.Exec varchar(128)
declare @.RC int
declare @.Error int
declare @.Subject varchar(128)
declare @.Server varchar(128)
declare @.Recipient varchar(128)
set @.Server = @.@.ServerName
set @.DBName = (select DB_Name())
set @.Exec = 'dbcc checkdb(''' + @.DBName + ''')' + 'WITH NO_INFOMSGS'
set @.Subject = 'Corruption in ' + @.DBName + '.!!!'
set @.Recipient = ''
exec (@.exec)
select @.Error = @.@.error
if @.Error <> 0
exec @.RC = master.dbo.xp_smtp_sendmail
@.FROM = @.Server
,@.TO = @.Recipient
,@.Subject = @.Subject
,@.server = N'smtpmail.azdes.gov'
,@.Port = 25
TIA,
ChrisR
Chris,
DBCC CHECKDB is not a stored procedure and I don't think using the @.@.ERROR
global variable is what you're looking for. For this just create a new job
to execute the DBCC CHECKDB statement for a given database with the
instructions to email you on failure and schedule the job.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:CCA21D09-B8B2-40BB-BD1F-CB9C04732EAA@.microsoft.com...
>I want to have my own DBCC tool. The problem I have with the Maintenance
>Plan
> DBCC is I only want to be emailed when I have corruption. Not every day
> for
> every DB. I wrote a proc, but what Im finding is that @.@.error still
> returns a
> 0 even if there are certain types of corruption, so my proc is flawed.
> Does
> anyone have another idea how I can accomplish my goals?
> alter procedure admin_DBCCCheckDB
> as
> declare @.DBName varchar(128)
> declare @.Exec varchar(128)
> declare @.RC int
> declare @.Error int
> declare @.Subject varchar(128)
> declare @.Server varchar(128)
> declare @.Recipient varchar(128)
> set @.Server = @.@.ServerName
> set @.DBName = (select DB_Name())
> set @.Exec = 'dbcc checkdb(''' + @.DBName + ''')' + 'WITH NO_INFOMSGS'
> set @.Subject = 'Corruption in ' + @.DBName + '.!!!'
> set @.Recipient = ''
> exec (@.exec)
> select @.Error = @.@.error
> if @.Error <> 0
> exec @.RC = master.dbo.xp_smtp_sendmail
> @.FROM = @.Server
> ,@.TO = @.Recipient
> ,@.Subject = @.Subject
> ,@.server = N'smtpmail.azdes.gov'
> ,@.Port = 25
> --
> TIA,
> ChrisR
|||No need to use dynamic SQL for this. CHECKDB accepts a variable, so you can catch the error after
and do additional steps if you need to. But it is easy enough to have Agent just act On Success/On
Error also. It is up to you, what makes more sense and easier for you. Here's the script I ran
against a bad database to test it:
DECLARE @.db sysname, @.err int
SET @.db = 'badpubs'
DBCC CHECKDB(@.db) WITH NO_INFOMSGS
SET @.err = @.@.ERROR
IF @.err <> 0
SELECT 'Ouch, we have a problem', @.err
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:CCA21D09-B8B2-40BB-BD1F-CB9C04732EAA@.microsoft.com...
>I want to have my own DBCC tool. The problem I have with the Maintenance Plan
> DBCC is I only want to be emailed when I have corruption. Not every day for
> every DB. I wrote a proc, but what Im finding is that @.@.error still returns a
> 0 even if there are certain types of corruption, so my proc is flawed. Does
> anyone have another idea how I can accomplish my goals?
> alter procedure admin_DBCCCheckDB
> as
> declare @.DBName varchar(128)
> declare @.Exec varchar(128)
> declare @.RC int
> declare @.Error int
> declare @.Subject varchar(128)
> declare @.Server varchar(128)
> declare @.Recipient varchar(128)
> set @.Server = @.@.ServerName
> set @.DBName = (select DB_Name())
> set @.Exec = 'dbcc checkdb(''' + @.DBName + ''')' + 'WITH NO_INFOMSGS'
> set @.Subject = 'Corruption in ' + @.DBName + '.!!!'
> set @.Recipient = ''
> exec (@.exec)
> select @.Error = @.@.error
> if @.Error <> 0
> exec @.RC = master.dbo.xp_smtp_sendmail
> @.FROM = @.Server
> ,@.TO = @.Recipient
> ,@.Subject = @.Subject
> ,@.server = N'smtpmail.azdes.gov'
> ,@.Port = 25
> --
> TIA,
> ChrisR

home made corruption checker

I want to have my own DBCC tool. The problem I have with the Maintenance Plan
DBCC is I only want to be emailed when I have corruption. Not every day for
every DB. I wrote a proc, but what Im finding is that @.@.error still returns a
0 even if there are certain types of corruption, so my proc is flawed. Does
anyone have another idea how I can accomplish my goals?
alter procedure admin_DBCCCheckDB
as
declare @.DBName varchar(128)
declare @.Exec varchar(128)
declare @.RC int
declare @.Error int
declare @.Subject varchar(128)
declare @.Server varchar(128)
declare @.Recipient varchar(128)
set @.Server = @.@.ServerName
set @.DBName = (select DB_Name())
set @.Exec = 'dbcc checkdb(''' + @.DBName + ''')' + 'WITH NO_INFOMSGS'
set @.Subject = 'Corruption in ' + @.DBName + '.!!!'
set @.Recipient = ''
exec (@.exec)
select @.Error = @.@.error
if @.Error <> 0
exec @.RC = master.dbo.xp_smtp_sendmail
@.FROM = @.Server
,@.TO = @.Recipient
,@.Subject = @.Subject
,@.server = N'smtpmail.azdes.gov'
,@.Port = 25
--
TIA,
ChrisRChris,
DBCC CHECKDB is not a stored procedure and I don't think using the @.@.ERROR
global variable is what you're looking for. For this just create a new job
to execute the DBCC CHECKDB statement for a given database with the
instructions to email you on failure and schedule the job.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:CCA21D09-B8B2-40BB-BD1F-CB9C04732EAA@.microsoft.com...
>I want to have my own DBCC tool. The problem I have with the Maintenance
>Plan
> DBCC is I only want to be emailed when I have corruption. Not every day
> for
> every DB. I wrote a proc, but what Im finding is that @.@.error still
> returns a
> 0 even if there are certain types of corruption, so my proc is flawed.
> Does
> anyone have another idea how I can accomplish my goals?
> alter procedure admin_DBCCCheckDB
> as
> declare @.DBName varchar(128)
> declare @.Exec varchar(128)
> declare @.RC int
> declare @.Error int
> declare @.Subject varchar(128)
> declare @.Server varchar(128)
> declare @.Recipient varchar(128)
> set @.Server = @.@.ServerName
> set @.DBName = (select DB_Name())
> set @.Exec = 'dbcc checkdb(''' + @.DBName + ''')' + 'WITH NO_INFOMSGS'
> set @.Subject = 'Corruption in ' + @.DBName + '.!!!'
> set @.Recipient = ''
> exec (@.exec)
> select @.Error = @.@.error
> if @.Error <> 0
> exec @.RC = master.dbo.xp_smtp_sendmail
> @.FROM = @.Server
> ,@.TO = @.Recipient
> ,@.Subject = @.Subject
> ,@.server = N'smtpmail.azdes.gov'
> ,@.Port = 25
> --
> TIA,
> ChrisR|||No need to use dynamic SQL for this. CHECKDB accepts a variable, so you can catch the error after
and do additional steps if you need to. But it is easy enough to have Agent just act On Success/On
Error also. It is up to you, what makes more sense and easier for you. Here's the script I ran
against a bad database to test it:
DECLARE @.db sysname, @.err int
SET @.db = 'badpubs'
DBCC CHECKDB(@.db) WITH NO_INFOMSGS
SET @.err = @.@.ERROR
IF @.err <> 0
SELECT 'Ouch, we have a problem', @.err
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:CCA21D09-B8B2-40BB-BD1F-CB9C04732EAA@.microsoft.com...
>I want to have my own DBCC tool. The problem I have with the Maintenance Plan
> DBCC is I only want to be emailed when I have corruption. Not every day for
> every DB. I wrote a proc, but what Im finding is that @.@.error still returns a
> 0 even if there are certain types of corruption, so my proc is flawed. Does
> anyone have another idea how I can accomplish my goals?
> alter procedure admin_DBCCCheckDB
> as
> declare @.DBName varchar(128)
> declare @.Exec varchar(128)
> declare @.RC int
> declare @.Error int
> declare @.Subject varchar(128)
> declare @.Server varchar(128)
> declare @.Recipient varchar(128)
> set @.Server = @.@.ServerName
> set @.DBName = (select DB_Name())
> set @.Exec = 'dbcc checkdb(''' + @.DBName + ''')' + 'WITH NO_INFOMSGS'
> set @.Subject = 'Corruption in ' + @.DBName + '.!!!'
> set @.Recipient = ''
> exec (@.exec)
> select @.Error = @.@.error
> if @.Error <> 0
> exec @.RC = master.dbo.xp_smtp_sendmail
> @.FROM = @.Server
> ,@.TO = @.Recipient
> ,@.Subject = @.Subject
> ,@.server = N'smtpmail.azdes.gov'
> ,@.Port = 25
> --
> TIA,
> ChrisRsql