Tuesday, March 20, 2012
Can't access Report Manager on another computer
Windows XP Pro boxes that are part of the same Windows workgroup. I
need to deploy reports from one box to the other, but I can't see the
Report Manager on the opposing machine, even though I can see it
locally on the respective machine.
I know we're talking beta here, but I need to give a coworker a way to
have access to all our reports on his laptop. Since Reporting
Services for SQL 2000 requires a server, the only way he and I can
have the reports locally on Win XP Pro is via Reporting Services 2005.
Any idea how I can get access to his Report Manager? When I go to
Report Manager on my machine, I go to
"http://MyComputerName/Reports$2005", which works fine. When I'm on
his machine and go to Report Manager, I go to
"http://HisComputerName/Reports$2005" and that works fine. When I try
the same path from my computer, I get a "page not found" error.
I am a local administrator on his machine and have full directory
access (e.g. //ComputerName/C$). I checked the IIS permissions for
his Reports$2005 virtual directory and the Directory Security
authentication method is set to Integrated Windows authentication. I
tried Anonymous access, but that didn't help. Any ideas?I figured it out. Service Pack 2 for Win XP Pro was installed on the
remote machine, so the firewall was preventing me from getting to the
Report Server. I simply disabled the firewall temporarily so I could
deploy my reports. I didn't know how to configure the firewall to
allow me to access the computer, so I found that disabling the
firewall was the best method.
Anyway, that solved my problem.
steve.pantazis@.gmail.com (Steve Pantazis) wrote in message news:<437b6286.0409250937.485cb6ac@.posting.google.com>...
> I have Reporting Services for SQL Server 2005 (beta 2) installed on 2
> Windows XP Pro boxes that are part of the same Windows workgroup. I
> need to deploy reports from one box to the other, but I can't see the
> Report Manager on the opposing machine, even though I can see it
> locally on the respective machine.
> I know we're talking beta here, but I need to give a coworker a way to
> have access to all our reports on his laptop. Since Reporting
> Services for SQL 2000 requires a server, the only way he and I can
> have the reports locally on Win XP Pro is via Reporting Services 2005.
> Any idea how I can get access to his Report Manager? When I go to
> Report Manager on my machine, I go to
> "http://MyComputerName/Reports$2005", which works fine. When I'm on
> his machine and go to Report Manager, I go to
> "http://HisComputerName/Reports$2005" and that works fine. When I try
> the same path from my computer, I get a "page not found" error.
> I am a local administrator on his machine and have full directory
> access (e.g. //ComputerName/C$). I checked the IIS permissions for
> his Reports$2005 virtual directory and the Directory Security
> authentication method is set to Integrated Windows authentication. I
> tried Anonymous access, but that didn't help. Any ideas?sql
Can't access properties on Stored Procedures
Hi. I have set up an instance of SQL 2005 on my local computer. I use MS SQL Server Management Studio to login into my 2005 instance via Windows login. When I expand "Stored Procedures" under "Programmability" of the Database I want and go to a stored procedure and right click, I don't see the "properities" selection.
I know it's there because I can get to it on other instances but I can't get to it on my local instance. I added my windows user to my Logins and then to my database users but it didn't help.
Can anyone please tell me what I need to do so I can access the properties of the stored procedures?
Thanks
Your procedure was created with encryption option. Because this you can′t see the contents.
|||Its either an encryption problem (like already mentioned by the other poster) or you don′t have the appropiate permissions viewing the properties. Which access level does the account you are using have ? Is there a pas lock on the stored procedure symbol ?Jens K. Suessmeyer.
http://www.sqlserver2005.de
Can't access my own report
and a laptop are on the network with DC. I am using http://devcompip/reports
but I am getting prompted for the network password. I am trying to enter it
but it keeps prompting.
What's a problem?
Thanks for help.On Jun 22, 4:32 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
> I am trying to access my report from my laptop. Both development computer
> and a laptop are on the network with DC. I am usinghttp://devcompip/reports
> but I am getting prompted for the network password. I am trying to enter it
> but it keeps prompting.
> What's a problem?
> Thanks for help.
The most common reasons are:
- If you are using a non-IE browser, this may cause the problem.
- If you have the anonymous permissions setup on either the Reports or
ReportServer virtual directory in IIS. You may want to set up Windows
Authentication w/the standard IUSR_MachineName user and allow IIS to
control the password.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I once had another problem. My server was using DHCP and I had this happen
to me. I changed to a fixed IP address and everything was fine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1182576182.834732.295990@.m36g2000hse.googlegroups.com...
> On Jun 22, 4:32 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> I am trying to access my report from my laptop. Both development computer
>> and a laptop are on the network with DC. I am
>> usinghttp://devcompip/reports
>> but I am getting prompted for the network password. I am trying to enter
>> it
>> but it keeps prompting.
>> What's a problem?
>> Thanks for help.
>
> The most common reasons are:
> - If you are using a non-IE browser, this may cause the problem.
> - If you have the anonymous permissions setup on either the Reports or
> ReportServer virtual directory in IIS. You may want to set up Windows
> Authentication w/the standard IUSR_MachineName user and allow IIS to
> control the password.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Can't access msde installation from network
connect to it from another computer, it doesn't allow me to log on. Is it a
internal limit?
MSDE doesn't by default have network connectivity turned on. Enable using svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hawz" <ohawz@.hotmail.com> wrote in message news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> I've installed a msde copy on a Win2000 pro computer, but when I try to
> connect to it from another computer, it doesn't allow me to log on. Is it a
> internal limit?
>
|||I've enabled tcp/ip, named pipe and multi-protocal. But still can't get
connected. It says "General network error. Please check network document
ConnectionOpen (PreLoginHandshake()"
And I also can't use telnet to connect to 1433 port.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ObJ9CvyNEHA.2708@.TK2MSFTNGP11.phx.gbl...
> MSDE doesn't by default have network connectivity turned on. Enable using
svrnetcn.exe.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Hawz" <ohawz@.hotmail.com> wrote in message
news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
it a
>
|||Perhaps there's a firewall in between?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hawz" <ohawz@.hotmail.com> wrote in message news:%2324RZQ7NEHA.644@.tk2msftngp13.phx.gbl...
> I've enabled tcp/ip, named pipe and multi-protocal. But still can't get
> connected. It says "General network error. Please check network document
> ConnectionOpen (PreLoginHandshake()"
> And I also can't use telnet to connect to 1433 port.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ObJ9CvyNEHA.2708@.TK2MSFTNGP11.phx.gbl...
> svrnetcn.exe.
> news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> it a
>
|||This might help:
http://support.microsoft.com/default...b;en-us;826829
-oj
http://www.rac4sql.net
"Hawz" <ohawz@.hotmail.com> wrote in message
news:%2324RZQ7NEHA.644@.tk2msftngp13.phx.gbl...
> I've enabled tcp/ip, named pipe and multi-protocal. But still can't get
> connected. It says "General network error. Please check network document
> ConnectionOpen (PreLoginHandshake()"
> And I also can't use telnet to connect to 1433 port.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ObJ9CvyNEHA.2708@.TK2MSFTNGP11.phx.gbl...
> svrnetcn.exe.
> news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> it a
>
Thursday, March 8, 2012
Cannot uninstall sql server express
I have successfully uninstalled instance of sql server, but I cannot uninstall the workstation.
here are the log that I have :
=== Verbose logging started: 11/23/2006 13:06:11 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: E:\Original\SQL2005Ent\32 bit\Servers\setup.exe ===
MSI (c) (04:28) [13:06:11:021]: Resetting cached policy values
MSI (c) (04:28) [13:06:11:021]: Machine policy value 'Debug' is 0
MSI (c) (04:28) [13:06:11:021]: ******* RunEngine:
******* Product: E:\Original\SQL2005Ent\32 bit\Servers\Setup\SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (c) (04:28) [13:06:11:021]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (04:28) [13:06:11:021]: Grabbed execution mutex.
MSI (c) (04:28) [13:06:11:036]: Cloaking enabled.
MSI (c) (04:28) [13:06:11:036]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (04:28) [13:06:11:068]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (c) (04:28) [13:06:11:068]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (04:28) [13:06:11:068]: MainEngineThread is returning 1618
=== Verbose logging stopped: 11/23/2006 13:06:11 ===
Please help
What error are you seeing? Can you search your install/uninstall logs for the text string "value 3" and post the error message a few lines above?
Thanks,
Sam Lester (MSFT)
Uninstall workstation?
What workstation you're referring.
|||Error 1618 means: Another installation is already in progress. Complete that installation before proceeding with this install.
There was another installation running at the same time you tried to uninstall SQL Express. Uninstall will work when you kick off setup later again.
Cannot uninstall sql server express
I have successfully uninstalled instance of sql server, but I cannot uninstall the workstation.
here are the log that I have :
=== Verbose logging started: 11/23/2006 13:06:11 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: E:\Original\SQL2005Ent\32 bit\Servers\setup.exe ===
MSI (c) (04:28) [13:06:11:021]: Resetting cached policy values
MSI (c) (04:28) [13:06:11:021]: Machine policy value 'Debug' is 0
MSI (c) (04:28) [13:06:11:021]: ******* RunEngine:
******* Product: E:\Original\SQL2005Ent\32 bit\Servers\Setup\SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (c) (04:28) [13:06:11:021]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (04:28) [13:06:11:021]: Grabbed execution mutex.
MSI (c) (04:28) [13:06:11:036]: Cloaking enabled.
MSI (c) (04:28) [13:06:11:036]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (04:28) [13:06:11:068]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (c) (04:28) [13:06:11:068]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (04:28) [13:06:11:068]: MainEngineThread is returning 1618
=== Verbose logging stopped: 11/23/2006 13:06:11 ===
Please help
What error are you seeing? Can you search your install/uninstall logs for the text string "value 3" and post the error message a few lines above?
Thanks,
Sam Lester (MSFT)
Uninstall workstation?
What workstation you're referring.
|||Error 1618 means: Another installation is already in progress. Complete that installation before proceeding with this install.
There was another installation running at the same time you tried to uninstall SQL Express. Uninstall will work when you kick off setup later again.
Saturday, February 25, 2012
cannot start report server on local computer
HI,
I tried to deploy reports on locahost. Yet, I still need to start the mssqlserver service on local computer. I tried all the possibilities shown from the help but still i can't have it started. How will i start mssqlserver service on local computer alone?
thanks
soWillingToLearn,
What are your settings for the msSQLserver service LogOn? Can you check your application log file under Event Viewer to see what error message is being generated.
Ham
Thursday, February 16, 2012
Cannot see server name in the pick list
The very first task I wanted to do is to convert and Access database to SQL. For that reason, I also installed "Microsoft SQL Server Migration Assistant for Access". In that application I cannot even see any server name when the wizard asks which server to choose. I also tried to start/stop "Sql Server Browser" service. When I stop the service, the pick list becomes empty and when I start the service the pick list has only SQLEXPRESS.
So, how can I see or pick MSSQLSERVER to make a connection in either applications? Please note I am VERY NEW to SQL Server and I appreciate your answers with that consideration.
Thans in advance
Hi, what's your installation sequence? You installed MS SQL Dev first, then VS 2005 (which contains SQL Expr 2005)? or VS 2005 first then MSSQLDev?|||I installed VS 2005 and used it for many months then installed the SQL DVD that come with the VS 2005 pack.Tuesday, February 14, 2012
Cannot See a Newly Installed SQL Server 2000 (No Active Directory)
has Windows-2003 Server on it. Now, we cannot get access to that
database server from other computers. Seem like this may be an issue
with Active Directory.
Our network consists of Windows-2000 Servers (SP 4) and Windows-2000
workstations and Windows-XP workstations. We also have SQL Server 2000
(SP2) in three Windows-2000 servers. All work fine. Recently, we get a
new server that has already had Windows-2003 Server pre-installed.
After we have installed SQL Server 2000 (SP 3A) on the new server, we
find that we cannot get access to that new database server from other
computers.
I have tried connecting to that new database server using Query
Analyzer (using both the sa account and Windows Authentication), and I
get this error message:
Unable to connect to server NEWDBSRV:
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
I have tried connecting to that new database server using ISQL (using
both the sa account and Windows Authentication), and I get this error
message:
DB-Library: Unable to connect: SQL Server is unavailable or does not
exist.
Unable to connect: SQL Server does not exist or network access
denied.
Net-Library error 53: ConnectionOpen (Connect()).
I have also tried to register the new database server using Enterprise
Manager (again, using both the sa account and Windows Authentication),
and I get this error message:
NEWDBSRV - SQL Server does not exist or access denied.
ConnectionOpen(Connect())
The only way that I can get access to the new database server is to
open Enterprise Manager directly on the new server.
I have compared the properties of the new database server and those of
the other existing database servers. The only differences are:
-Other database servers are running Windows-2000. The new database
server is running Windows-2003.
-The new database server is missing the "Active Directory" page-tag
when I check its properties using Enterprise Manager. We use Active
Directory in our network, and the Active Directory is being run from a
Windows-2000 server (that is currently also a database server).
According to our network administrator, he has already put the new
server into our Active Directory. He doesn't know why it is missing
the Active Directory page-tag. He believes this has something to do
with its having Windows-2003 that is different from other servers
(that have Windows-2000).
Thanks in advance for any info.
Jay Chanif you can connect with Query analizer on the server but not on a client
then tcp/ip is not activated. Look for SVRNETCN.exe (normaly in
C:\Programs\Microsoft SQL Server\80\Tools\Binn) and check if
tcp/ip is activated. Since version sp3A tcp/ip is disabled per default,
if you do the installation without DISABLENETWORKPROTOCOLS=0
Read more about it in "3.7.3 MSDE 2000 Setup Parameters" on
http://support.microsoft.com/defaul...0/SP3ReadMe.asp
hth,
Helmut|||Thanks for the suggestion.
Our network administrator has fixed this problem. The IP address in
the DNS server didn't match the one that was actually assigned to the
new server. The story was that he let the installation program to pick
a IP address that ended up saved in the DNS server. Later on when he
assigned the actual IP address to the new server, he didn't realize
that the DNS server still had the outdated IP address. I am not
exactly sure whether I get the story right; but this sounds like the
one our network administrator told me.
Jay Chan