Newbie question about Office version on client machine

Does it matter what version of Office is installed on the clients
machine for opening reports generated by reporting Services?
The reason I am asking is because our users are getting an office
upgrade from 2000 to XP on their machines.No, it does not matter.
"Amit" <amit.gaind@.gmail.com> wrote in message
news:1174400171.358992.243630@.l75g2000hse.googlegroups.com...
> Does it matter what version of Office is installed on the clients
> machine for opening reports generated by reporting Services?
> The reason I am asking is because our users are getting an office
> upgrade from 2000 to XP on their machines.
>|||On Mar 20, 10:42 am, "Norman Yuan" <NotR...@.NotReal.not> wrote:
> No, it does not matter.
> "Amit" <amit.ga...@.gmail.com> wrote in message
> news:1174400171.358992.243630@.l75g2000hse.googlegroups.com...
>
> > Does it matter what version of Office is installed on the clients
> > machine for opening reports generated by reporting Services?
> > The reason I am asking is because our users are getting an office
> > upgrade from 2000 to XP on their machines.- Hide quoted text -
> - Show quoted text -
thank you.

newbie question -- error when connecting via System DSN on any network but the SQL Servers

I'm very new to using SQL Server. All I'm trying to do at the moment, is
create a System DSN on a Windows 2000 Professional desktop machine to
connect to a SQL Server 2000 server which is running on a different
network. When I try the DSN while connected to the SAME network that the
SQL Server machine is on, it works fine. But when I connect from any
other network, I receive the following error:
Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpent
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied.

Here are the settings that I'm using for my System DSN:
Name: test
Which SQL Server do you want to connect to? 129.22.180.203
* With SQL Server Authentication using a login ID and password entered by
the user
* Connect to SQL Server to obtain default settings for the additional
configuration options
Login ID: SA
Password: <correct password entered
And in the Client Configuration:
Server Alias: 129.22.180.203
Network libraries: TCP/IP
Server Name: 129.22.180.203
* Dynamically determine port

Also, the driver is:
Microsoft SQL Server ODBC Driver version 03.85.1025

Please, if anyone has any ideas on what I am doing wrong, I can use all
the help I can get!!
--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/sheree <sah18@.case.edu> wrote in message news:<opsb5642gy6l2js5@.uh007637>...
> I'm very new to using SQL Server. All I'm trying to do at the moment, is
> create a System DSN on a Windows 2000 Professional desktop machine to
> connect to a SQL Server 2000 server which is running on a different
> network. When I try the DSN while connected to the SAME network that the
> SQL Server machine is on, it works fine. But when I connect from any
> other network, I receive the following error:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 10061
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpent
> (Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
> exist or access denied.
> Here are the settings that I'm using for my System DSN:
> Name: test
> Which SQL Server do you want to connect to? 129.22.180.203
> * With SQL Server Authentication using a login ID and password entered by
> the user
> * Connect to SQL Server to obtain default settings for the additional
> configuration options
> Login ID: SA
> Password: <correct password entered>
> And in the Client Configuration:
> Server Alias: 129.22.180.203
> Network libraries: TCP/IP
> Server Name: 129.22.180.203
> * Dynamically determine port
> Also, the driver is:
> Microsoft SQL Server ODBC Driver version 03.85.1025
> Please, if anyone has any ideas on what I am doing wrong, I can use all
> the help I can get!!

I'm not sure what you mean by "a different network". If you mean that
the networks are physically separated by a firewall, or if you're
connecting over a VPN, then you might need to open the ports for
MSSQL:

http://support.microsoft.com/defaul...2&Product=sql2k

Simon|||Simon,
By "different network", I mean the following:
The SQL Server is running on a Windows 2000 Server machine that is located
on a University network. If I am on any machine that is also connected to
the University network, OR if I VPN into the University network, I can
successfully connect to the SQL Server in my DSN connection with the
parameters I gave in my original posting. However, if I try from my
office computer which is on a hospital network (and IS behind a firewall)
or if I try from any computer where I'm dialed up to my ISP (no firewall
would block anything here) I still can't connect to the SQL Server in my
DSN connection.
So I really don't think it's the port that is being blocked.

Are there any connection settings in SQL Server itself that I may have
configured incorrectly? Since I know so little about the software, I'm
not sure where even to begin to look.

Thanks for helping out!
-sheree

On 4 Aug 2004 01:16:19 -0700, Simon Hayes <sql@.hayes.ch> wrote:

> sheree <sah18@.case.edu> wrote in message
> news:<opsb5642gy6l2js5@.uh007637>...
>> I'm very new to using SQL Server. All I'm trying to do at the moment,
>> is
>> create a System DSN on a Windows 2000 Professional desktop machine to
>> connect to a SQL Server 2000 server which is running on a different
>> network. When I try the DSN while connected to the SAME network that
>> the
>> SQL Server machine is on, it works fine. But when I connect from any
>> other network, I receive the following error:
>> Connection failed:
>> SQLState: '01000'
>> SQL Server Error: 10061
>> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpent
>> (Connect()).
>> Connection failed:
>> SQLState: '08001'
>> SQL Server Error: 17
>> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
>> exist or access denied.
>>
>> Here are the settings that I'm using for my System DSN:
>> Name: test
>> Which SQL Server do you want to connect to? 129.22.180.203
>> * With SQL Server Authentication using a login ID and password entered
>> by
>> the user
>> * Connect to SQL Server to obtain default settings for the additional
>> configuration options
>> Login ID: SA
>> Password: <correct password entered>
>>
>> And in the Client Configuration:
>> Server Alias: 129.22.180.203
>> Network libraries: TCP/IP
>> Server Name: 129.22.180.203
>> * Dynamically determine port
>>
>> Also, the driver is:
>> Microsoft SQL Server ODBC Driver version 03.85.1025
>>
>> Please, if anyone has any ideas on what I am doing wrong, I can use all
>> the help I can get!!
> I'm not sure what you mean by "a different network". If you mean that
> the networks are physically separated by a firewall, or if you're
> connecting over a VPN, then you might need to open the ports for
> MSSQL:
> http://support.microsoft.com/defaul...2&Product=sql2k
> Simon

--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/|||> However, if I try from my
> office computer which is on a hospital network (and IS behind a firewall)
> or if I try from any computer where I'm dialed up to my ISP (no firewall
> would block anything here) I still can't connect to the SQL Server in my
> DSN connection.
> So I really don't think it's the port that is being blocked.

From your description, it seems you are trying to connect over the public
internet to the SQL Server at your university. Port 1433 needs to be open
to allow this and it is likely that the firewall at the university has the
port closed for security reasons. It works when you are connected to the
university LAN or VPN because the firewall doesn't block 1433 in those
cases.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"sheree" <sah18@.case.edu> wrote in message
news:opsb7ky5r56l2js5@.v129-22-124-109.vclient.cwru.edu...
> Simon,
> By "different network", I mean the following:
> The SQL Server is running on a Windows 2000 Server machine that is located
> on a University network. If I am on any machine that is also connected to
> the University network, OR if I VPN into the University network, I can
> successfully connect to the SQL Server in my DSN connection with the
> parameters I gave in my original posting. However, if I try from my
> office computer which is on a hospital network (and IS behind a firewall)
> or if I try from any computer where I'm dialed up to my ISP (no firewall
> would block anything here) I still can't connect to the SQL Server in my
> DSN connection.
> So I really don't think it's the port that is being blocked.
> Are there any connection settings in SQL Server itself that I may have
> configured incorrectly? Since I know so little about the software, I'm
> not sure where even to begin to look.
> Thanks for helping out!
> -sheree
>
> On 4 Aug 2004 01:16:19 -0700, Simon Hayes <sql@.hayes.ch> wrote:
> > sheree <sah18@.case.edu> wrote in message
> > news:<opsb5642gy6l2js5@.uh007637>...
> >> I'm very new to using SQL Server. All I'm trying to do at the moment,
> >> is
> >> create a System DSN on a Windows 2000 Professional desktop machine to
> >> connect to a SQL Server 2000 server which is running on a different
> >> network. When I try the DSN while connected to the SAME network that
> >> the
> >> SQL Server machine is on, it works fine. But when I connect from any
> >> other network, I receive the following error:
> >> Connection failed:
> >> SQLState: '01000'
> >> SQL Server Error: 10061
> >> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpent
> >> (Connect()).
> >> Connection failed:
> >> SQLState: '08001'
> >> SQL Server Error: 17
> >> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
> >> exist or access denied.
> >>
> >> Here are the settings that I'm using for my System DSN:
> >> Name: test
> >> Which SQL Server do you want to connect to? 129.22.180.203
> >> * With SQL Server Authentication using a login ID and password entered
> >> by
> >> the user
> >> * Connect to SQL Server to obtain default settings for the additional
> >> configuration options
> >> Login ID: SA
> >> Password: <correct password entered>
> >>
> >> And in the Client Configuration:
> >> Server Alias: 129.22.180.203
> >> Network libraries: TCP/IP
> >> Server Name: 129.22.180.203
> >> * Dynamically determine port
> >>
> >> Also, the driver is:
> >> Microsoft SQL Server ODBC Driver version 03.85.1025
> >>
> >> Please, if anyone has any ideas on what I am doing wrong, I can use all
> >> the help I can get!!
> > I'm not sure what you mean by "a different network". If you mean that
> > the networks are physically separated by a firewall, or if you're
> > connecting over a VPN, then you might need to open the ports for
> > MSSQL:
http://support.microsoft.com/defaul...2&Product=sql2k
> > Simon
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/m2/|||Dan,
Can another port be used for SQL Server to run on (rather than using the
default port 1433, which is what it is currently running on)? It might be
easier for me to use a different port that is already open at the
university, rather than attempt to request that they open port 1433
(unlikely they will do this).
Thanks so much for your help!
-sheree

On Wed, 04 Aug 2004 13:13:12 GMT, Dan Guzman
<danguzman@.nospam-earthlink.net> wrote:

> From your description, it seems you are trying to connect over the public
> internet to the SQL Server at your university. Port 1433 needs to be
> open
> to allow this and it is likely that the firewall at the university has
> the
> port closed for security reasons. It works when you are connected to the
> university LAN or VPN because the firewall doesn't block 1433 in those
> cases.|||sheree (sah18@.case.edu) writes:
> Can another port be used for SQL Server to run on (rather than using the
> default port 1433, which is what it is currently running on)? It might be
> easier for me to use a different port that is already open at the
> university, rather than attempt to request that they open port 1433

Yes, it is possible to use another port. (Which would affect everyone
using that server, as SQL Server uses only one port at a time.) No,
I don't think your university is likely to make SQL Server available on the
Internet on any port, least of all if you insist on using SQL Server
authentication.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Although it is certainly possible to configure SQL Server to listen on an
alternate port, it appears the SQL Server is configured to use 1433 because
your working local/VPN connections use the default port.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"sheree" <sah18@.case.edu> wrote in message
news:opsb7mufwi6l2js5@.v129-22-124-109.vclient.cwru.edu...
> Dan,
> Can another port be used for SQL Server to run on (rather than using the
> default port 1433, which is what it is currently running on)? It might be
> easier for me to use a different port that is already open at the
> university, rather than attempt to request that they open port 1433
> (unlikely they will do this).
> Thanks so much for your help!
> -sheree
>
> On Wed, 04 Aug 2004 13:13:12 GMT, Dan Guzman
> <danguzman@.nospam-earthlink.net> wrote:
> > From your description, it seems you are trying to connect over the
public
> > internet to the SQL Server at your university. Port 1433 needs to be
> > open
> > to allow this and it is likely that the firewall at the university has
> > the
> > port closed for security reasons. It works when you are connected to
the
> > university LAN or VPN because the firewall doesn't block 1433 in those
> > cases.

Newbie question

I have installed MSDE2000 since a couple of weeks on my machine and its
running the database for a forum on the intranet. Could someone please tell
me, how can I make a regular back up of my database please?
Regards
Rahul
hi Rahul,
"Rahul Kumar" <rahul.kumar.remove_it@.sage.remove_it.com> ha scritto nel
messaggio news:eQTRboBlEHA.3536@.TK2MSFTNGP12.phx.gbl...
> I have installed MSDE2000 since a couple of weeks on my machine and its
> running the database for a forum on the intranet. Could someone please
tell
> me, how can I make a regular back up of my database please?
as MSDE does not provide graphical management utilities, you should resort
on Transact-SQL statement execution via oSql.exe, the command line
management tool available and bundled with it...
further info on how to use it can be found at
http://support.microsoft.com/default...;EN-US;q325003
for your convenience, you can have a look at a free prj of mine, available
at the link following my sign., which porvides a user interface similar to
Enterprise Manager, that includes that feature, graphically
further MSDE management tools, both free and commercial, can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
google for others
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Adrea! That was a great help!
Regards
Rahul
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2q3b2oFq9t8lU1@.uni-berlin.de...
> hi Rahul,
> "Rahul Kumar" <rahul.kumar.remove_it@.sage.remove_it.com> ha scritto nel
> messaggio news:eQTRboBlEHA.3536@.TK2MSFTNGP12.phx.gbl...
> tell
> as MSDE does not provide graphical management utilities, you should resort
> on Transact-SQL statement execution via oSql.exe, the command line
> management tool available and bundled with it...
> further info on how to use it can be found at
> http://support.microsoft.com/default...;EN-US;q325003
> for your convenience, you can have a look at a free prj of mine, available
> at the link following my sign., which porvides a user interface similar to
> Enterprise Manager, that includes that feature, graphically
> further MSDE management tools, both free and commercial, can be found at
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> google for others
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Newbie Q: SQL Redundancy

Hi, If I have two machine in a cluster
- if I install SQL on one will the installation replicate on the other or do I have to install both seperatly,
- if I have SQL operating on both nodes and I write SQL to one will it replicate over automatically (does it remove the need for SQL redundancy)
- would WebPages do the same.
sorry for the newbie questions but was finding it hard to get specific answers, any help would be appreciated.
Steve
SQL Cluster installation puts the binaries on whatever host nodes you
specify. You can add or remove nodes later if you need to. The clustered
data store is accessable from both nodes, but is arbitrated so that only one
host at a time owns it owns. The entire data store shifts to another node
during a failover. A failover appears like a SQL stop/start to the outside
world. If you have a SQL instance running on a different host node in the
same cluster, it will have a different set of databases and will appear like
(because it is) a separate SQL server.
I do not understand your question about WebPages.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:E7F75FFB-A439-4931-B7E5-80868A324720@.microsoft.com...
> Hi, If I have two machine in a cluster
> - if I install SQL on one will the installation replicate on the other or
do I have to install both seperatly,
> - if I have SQL operating on both nodes and I write SQL to one will it
replicate over automatically (does it remove the need for SQL redundancy)
> - would WebPages do the same.
> sorry for the newbie questions but was finding it hard to get specific
answers, any help would be appreciated.
> Steve
|||Setup will install SQL Server 2000 on both nodes. That is, it will install
the binaries and utilities on a local drive on each node and the data and
log files on the shared drive.
There is only one set of shared databses between the nodes. There is no
data redundancy; only high availability. So if you want data redundancy you
will need to use something like replication or log shipping.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Even in a SQL cluster, you have only one set of data (mounted by one node or
the other, but not both).
If you lose the storage solution or corrupt the data, you're toast. That's
where replication comes in.
Look at either NSI product (www.nsisoftware.com).
GeoCluster splits the storage under MSCS, so each node has its own copy -
although only one is active at a time.
DoubleTake replicates data between servers, and also from the active MSCS
node, to another server. This can be built in such a way that you could do
backups or snaps from the redundant server (which gives you some additional
restore and rollback capabilities).
jason
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:E7F75FFB-A439-4931-B7E5-80868A324720@.microsoft.com...
> Hi, If I have two machine in a cluster
> - if I install SQL on one will the installation replicate on the other or
do I have to install both seperatly,
> - if I have SQL operating on both nodes and I write SQL to one will it
replicate over automatically (does it remove the need for SQL redundancy)
> - would WebPages do the same.
> sorry for the newbie questions but was finding it hard to get specific
answers, any help would be appreciated.
> Steve

Newbie Q setting up MSDE

Hello. I've installed MSDE (Win2k machine, running asp.net on localhost),
and it says 'Not Connected' when I mouseover the icon in the system tray. I
opened the SQL Server service manager, and there are two empty fields-
Server and Services. Please, what do I put in these fields? Also, what
connection string would I use with MSDE. Thanks a lot
Justin Dutoit
hi Justin,
"Justin Dutoit" <anon@.anon.com> ha scritto nel messaggio
news:%23Gr48BqqEHA.3988@.tk2msftngp13.phx.gbl
> Hello. I've installed MSDE (Win2k machine, running asp.net on
> localhost), and it says 'Not Connected' when I mouseover the icon in
> the system tray. I opened the SQL Server service manager, and there
> are two empty fields- Server and Services. Please, what do I put in
> these fields? Also, what connection string would I use with MSDE.
> Thanks a lot
> Justin Dutoit
please verify, using the services applet (control panel->performance and
maintenance->administrative tools->services [on XP] , control
panel->administrative tools->services [on Win2k]) that your MSDE instance is
currently up and running...
you can then try typing in the service name of your MSDE instance to manage
it...
MSDE installs by default disabling network protocols and this can be an
issue for some ODBC related functions and, sometime, the SQL Server
instances are not enlisted by the Service Manager, as reported in
http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Newbie needs help

Hi,
I am using SQLEXPRESS running locally on my machine and am trying to create
a database (AdventureWorks) for an example that I am using. What complicates
this a bit is that this example is using NAnt. The local.properties.xml file
contains the following:
<?xml version="1.0"?>
<properties>
<property name="sqlToolsFolder" value="C:\Program Files\Microsoft SQL
Server\90\Tools\Binn"/>
<property name="osql.ConnectionString" value="-E"/>
<property name="initial.catalog" value="AdventureWorks"/>
<property name="config.ConnectionString" value="data
source=SQLEXPRESS;Integrated Security=SSPI;Initial
Catalog=${initial.catalog}"/> <property name="database.path"
value="C:\root\development\databases" />
<property name="osql.exe" value="${sqlToolsFolder}\osql.exe" />
</properties>
When I open the Enterprise Manager and run the script for attach.sql the
database is created fine.
when I run the "build builddb" I get the following error:
NAnt 0.85 (Build 0.85.2139.0; nightly; 11/9/2005)
Copyright (C) 2001-2005 Gerry Shaw
http://nant.sourceforge.net
Buildfile: file:///C:/root/development/playground/adventureworks/avworks.bui
ld
Target framework: Microsoft .NET Framework 2.0
Target(s) specified: builddb
[echo] Loading local.properties.xml
builddb:
exec.sql.template:
convert.template:
[copy] Copying 1 file to
'C:\root\development\playground\adventur
eworks\sql
\attach.sql'.
[exec] Msg 1813, Level 16, State 2, Server OHBOCXX99RMRVK, Line 1
[exec] Could not open new database 'AdventureWorks'. CREATE DATABASE is
aborted.
[exec] Msg 602, Level 21, State 50, Server OHBOCXX99RMRVK, Line 1
[exec] Could not find row in sysindexes for database ID 13, object ID
1, in
dex ID 1.
[exec] Run DBCC CHECKTABLE on sysindexes.
BUILD FAILED
C:\root\development\playground\adventure
works\avworks.build(60,10):
External Program Failed: C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\osq
l.exe (return code was 1)
Total time: 1.8 seconds.
When I installed SQLEXPRESS, I installed it using Windows Authentication and
I would think that Integrated Security would work. I'll bet I'm doing
something silly, but I've tried to figure it out with no luck.
thanks in advance!
BillChances are they are using the AdventureWorks sample database which come
populated with a bunch of sample data. You can download it here:
http://www.microsoft.com/downloads/...&displaylang=en
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
"Bill44077" <Bill44077@.discussions.microsoft.com> wrote in message
news:A1B3826A-0D0F-4B1F-804A-DB222842D778@.microsoft.com...
> Hi,
> I am using SQLEXPRESS running locally on my machine and am trying to
> create
> a database (AdventureWorks) for an example that I am using. What
> complicates
> this a bit is that this example is using NAnt. The local.properties.xml
> file
> contains the following:
> <?xml version="1.0"?>
> <properties>
> <property name="sqlToolsFolder" value="C:\Program Files\Microsoft SQL
> Server\90\Tools\Binn"/>
> <property name="osql.ConnectionString" value="-E"/>
> <property name="initial.catalog" value="AdventureWorks"/>
> <property name="config.ConnectionString" value="data
> source=SQLEXPRESS;Integrated Security=SSPI;Initial
> Catalog=${initial.catalog}"/> <property name="database.path"
> value="C:\root\development\databases" />
> <property name="osql.exe" value="${sqlToolsFolder}\osql.exe" />
> </properties>
> When I open the Enterprise Manager and run the script for attach.sql the
> database is created fine.
> when I run the "build builddb" I get the following error:
> NAnt 0.85 (Build 0.85.2139.0; nightly; 11/9/2005)
> Copyright (C) 2001-2005 Gerry Shaw
> http://nant.sourceforge.net
> Buildfile:
> file:///C:/root/development/playground/adventureworks/avworks.build
> Target framework: Microsoft .NET Framework 2.0
> Target(s) specified: builddb
> [echo] Loading local.properties.xml
> builddb:
>
> exec.sql.template:
>
> convert.template:
> [copy] Copying 1 file to
> 'C:\root\development\playground\adventur
eworks\sql
> \attach.sql'.
> [exec] Msg 1813, Level 16, State 2, Server OHBOCXX99RMRVK, Line 1
> [exec] Could not open new database 'AdventureWorks'. CREATE DATABA
SE
> is
> aborted.
> [exec] Msg 602, Level 21, State 50, Server OHBOCXX99RMRVK, Line 1
> [exec] Could not find row in sysindexes for database ID 13, object
ID
> 1, in
> dex ID 1.
> [exec] Run DBCC CHECKTABLE on sysindexes.
> BUILD FAILED
> C:\root\development\playground\adventure
works\avworks.build(60,10):
> External Program Failed: C:\Program Files\Microsoft SQL
> Server\90\Tools\Binn\osq
> l.exe (return code was 1)
> Total time: 1.8 seconds.
> When I installed SQLEXPRESS, I installed it using Windows Authentication
> and
> I would think that Integrated Security would work. I'll bet I'm doing
> something silly, but I've tried to figure it out with no luck.
> thanks in advance!
> Bill

Newbie needs a hand with SQL2005 Reports

I'm trying to run some reports on SQL 2005, but can't even pass the first step of launching the report builder. I have SQL2005 on my local machine, but the report server is installed on a remote server. I launched SQL Business Intelligence Development Studio, which brings Visual studio, but i keep getting a prompt to enter a connection string. How do i get the connection string, or how do i set up my datasource?

Help!

To answer your question, try the following, but i think you need to configure 'iis', as well as 'reporting services configuration' before hand:

open sql server business intelligence studio
file
new
project
report server project
ok
view
solution explorer
right click reports
add
new item
data source
add
edit
<enter your database details here>

...and so on

look up the microsoft tutorial for creating a basic report in 'sql server business intelligence studio' help

newbie IIS & MS SQL connection problem ;-(

Have successfully installed MS SQL on my Win XP Pro machine, created tables,
and a dsn, which is working fine in Dreamweaver. So far so good.

When I run the page on IIS I get the following:-

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
requested in login 'MenuPlanner'. Login fails.

I think it's permissions - anyone got any clues as to where to look?

TIA

GrantBuzby wrote:
> Have successfully installed MS SQL on my Win XP Pro machine, created
tables,
> and a dsn, which is working fine in Dreamweaver. So far so good.
> When I run the page on IIS I get the following:-
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
> requested in login 'MenuPlanner'. Login fails.
> I think it's permissions - anyone got any clues as to where to look?

You could see if the login MenuPlanner has got permissions to the
database you are logging in to. That would be a start.

--
David Rowland
For a good user and performance monitor, check DBMonitor
http://dbmonitor.tripod.com

> TIA
> Grant|||"dbmonitor" <dbmonitor_support@.hotmail.com> wrote in message
news:1107519068.678569.226760@.o13g2000cwo.googlegr oups.com...
> Buzby wrote:
>> Have successfully installed MS SQL on my Win XP Pro machine, created
> tables,
>> and a dsn, which is working fine in Dreamweaver. So far so good.
>>
>> When I run the page on IIS I get the following:-
>>
>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
>> requested in login 'MenuPlanner'. Login fails.
>>
>> I think it's permissions - anyone got any clues as to where to look?
> You could see if the login MenuPlanner has got permissions to the
> database you are logging in to. That would be a start.

This is what has got me - permissions are set up. I've created a dsn, which
I can run queries in Dreamweaver and filter results just fine. I'm having
trouble when running the page on my webserver (IIS which is working fine)

Stumped ;-(|||Buzby wrote:
> "dbmonitor" <dbmonitor_support@.hotmail.com> wrote in message
> news:1107519068.678569.226760@.o13g2000cwo.googlegr oups.com...
> > Buzby wrote:
> >> Have successfully installed MS SQL on my Win XP Pro machine,
created
> > tables,
> >> and a dsn, which is working fine in Dreamweaver. So far so good.
> >>
> >> When I run the page on IIS I get the following:-
> >>
> >> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> >> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
database
> >> requested in login 'MenuPlanner'. Login fails.
> >>
> >> I think it's permissions - anyone got any clues as to where to
look?
> > You could see if the login MenuPlanner has got permissions to the
> > database you are logging in to. That would be a start.
> This is what has got me - permissions are set up. I've created a dsn,
which
> I can run queries in Dreamweaver and filter results just fine. I'm
having
> trouble when running the page on my webserver (IIS which is working
fine)
> Stumped ;-(

Is MenuPlanner the database name or the login name?

If it is the database name, are you connecting to the database via a
userid/password or are you connecting with Windows interactive UserID?
--
David Rowland
For a good user and performance monitor, check DBMonitor
http://dbmonitor.tripod.com|||Buzby (gb@.pumpupthe.net) writes:
> Have successfully installed MS SQL on my Win XP Pro machine, created
> tables, and a dsn, which is working fine in Dreamweaver. So far so
> good.
> When I run the page on IIS I get the following:-
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
> requested in login 'MenuPlanner'. Login fails.
> I think it's permissions - anyone got any clues as to where to look?

Sounds like the login has a default db which does not exist, or the login
does have access to. Use sp_helplogins to check, use sp_defaultdb to change.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||On 2/4/05 5:37 PM, in article Xns95F3F003A2514Yazorman@.127.0.0.1, "Erland
Sommarskog" <esquel@.sommarskog.se> wrote:

> Buzby (gb@.pumpupthe.net) writes:
>> Have successfully installed MS SQL on my Win XP Pro machine, created
>> tables, and a dsn, which is working fine in Dreamweaver. So far so
>> good.
>>
>> When I run the page on IIS I get the following:-
>>
>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
>> requested in login 'MenuPlanner'. Login fails.
>>
>> I think it's permissions - anyone got any clues as to where to look?
> Sounds like the login has a default db which does not exist, or the login
> does have access to. Use sp_helplogins to check, use sp_defaultdb to change.

Yea, but a DSN is being used so we have to believe that MenuPlanner is the
name of the DSN Connection. I am assuming that the DSN was created on the
IIS server and connects successfully when you "test connection" in the ODBC
dialog.

I highly recommend using a DSN-less connection in your ASP pages. There is
lots of documentation on ADODB.

If you need some sample connection strings let me know.|||Gregory Dean (gdean@.datapex.com) writes:
> On 2/4/05 5:37 PM, in article Xns95F3F003A2514Yazorman@.127.0.0.1, "Erland
> Sommarskog" <esquel@.sommarskog.se> wrote:
>> Buzby (gb@.pumpupthe.net) writes:
>>> Have successfully installed MS SQL on my Win XP Pro machine, created
>>> tables, and a dsn, which is working fine in Dreamweaver. So far so
>>> good.
>>>
>>> When I run the page on IIS I get the following:-
>>>
>>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>>> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
>>> requested in login 'MenuPlanner'. Login fails.
>>>
>>> I think it's permissions - anyone got any clues as to where to look?
>>
>> Sounds like the login has a default db which does not exist, or the
>> login does have access to. Use sp_helplogins to check, use sp_defaultdb
>> to change.
> Yea, but a DSN is being used so we have to believe that MenuPlanner is
> the name of the DSN Connection. I am assuming that the DSN was created
> on the IIS server and connects successfully when you "test connection"
> in the ODBC dialog.

Not sure what you mean, but since SQL Server does not know what a DSN
is, MenuPlanner cannot be the name of the DNS. But it can be the
login name specified in the DSN.

> I highly recommend using a DSN-less connection in your ASP pages.

I echo that. DSN is a concept that I never understood the point with.
An extra layer that only causes hassle.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks one and all - it turned out it was an IIS permissions issue - however
I've taken on board what you have suggested and dsn less is the way we are
going!

Cheers

Buzby

Newbie Advice re: Installing SSRS

Hi, I've decided to install SSRS (2005) on my windows XP machine. I'm not very familiar with IIS (i'm currently using version 5.1) and I think between IIS and SSRS, i've managed to break something.

I've been looking at various articles to try and get some clarity on my predicament. However, i'm not getting any joy with them.s

I have located the logfiles (which I can provide). Unfortunately, I have no idea how to intepret the information contained therein.

Can anyone help?

Many thanks in advance

ClintPlease provide more information. First make sure every tab in the configuration tool is green. Then try to access your report server virtual directory. If there is an error on the web page please copy it here. Also copy the corresponding error in the log files.|||

Hi James, thank you for taking the time to answer me. I will endeavour to provide the information that you requested.

1. The configuration window - This is what i'm getting when I view it.

Picture held on my web site

2. When I try and browse to my Reporting Server (using I.E. 7) with the name http://<servername>/reports this is what I get.

Server Error in '/Reports' Application.

---

The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[Exception: The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.]

Microsoft.ReportingServices.Diagnostics.RSConfiguration.ThrowInvalidFormat(String element) +41

Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject) +1135

Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +972

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32

[ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.]

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +62

Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +296

Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +134

Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84

Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender, EventArgs e) +32

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

3. The error logs are very long so if you look at the bottom of the link above, you'll see links to the files. I'm sorry about the crude mechanism to provide the information to you. But I hope you can see access them.

Many thanks

Clint

|||

Can you open your RSWebApplication.config file(%ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportManager\RSWebApplication.config) and check the entries for ReportServerUrl and ReportServerVirtualDirectory. You have to specify ONLY one of them and not both.

For example,

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,
Sharmila

|||

Hi Sharmila, thanks for enquiring.

The contents of the configuration file is listed below:

The <servername> has replaced the name of my server.

Many thanks

Clint

-

<Configuration>

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

<Extensions>

<DeliveryUI>

<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">

<DefaultDeliveryExtension>True</DefaultDeliveryExtension>

<Configuration>

<RSEmailDPConfiguration>

<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>

</RSEmailDPConfiguration>

</Configuration>

</Extension>

<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>

</DeliveryUI>

</Extensions>

<Add Key="MaxActiveReqForOneUser" Value="20"/>

<Add Key="DisplayErrorLink" Value="true"/>

</Configuration>

|||

As seen in the config file, you have specified both ReportServerUrl and ReportServerVirtualDirectory. You can specify ONLY one.

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

Try something like this,

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

Hope this helps,

Sharmila

|||

Hi Sharmila, out of interest does specifying both make a difference? You clearly seem to imply that it does, I was just curious to know.

I'm going to try it now.

Regards

Clint

|||

I've just tried it with /reports and got this.

Error

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

Home

I also tried browsing to the /reportserver and got this.

--

Reporting Services Error

---

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

Can we check a few things?

1. Is RS service running? Is yes, can we restart and also retart IIS.

2. Open the config tool and see if all sections are configured properly as before(in the screenshot you provided).

3. Also, look in the log files to get more info on the internal error.

Thanks,
Sharmila

|||

Hi Sharmila,

I have tried to answer your questions below:

1. I've restarted IIS

2. The configuration tool reports the service states in exactly the same way as my screen shot.

3. The report logs from 19:30 (GMT) are listed below the screenshot. Do you want me to provide the latest logs (22:30)?

Thanks

Clint

|||

Yes, please provide the latest logs.

Thanks,

Sharmila

|||

As an FYI..., there is a similar post that addresses the same issue. - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=251336&SiteID=1

I just noticed that in the RSWebApplication.config, for ReportServerUrl, the Url is missing a "/" for http://. I'm assuming that it is just a typo. Can we just stop the RS service and start it again and also reset IIS.

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

Thanks,
Sharmila

|||

Hi. I've updated the logs here.

Thanks

Clint

|||

Hi. I've restarted the RS services and IIS and yes it was a typo.

Thank you

Clint

|||Do you have <xmlns=..."> in your web.config (both report server and report manager dir), rsreportserver.config or rswebapplication.config files? If so remove the line.

newbie - empty result set for all queries?

I am a newbie and have installed SQL Server myself on my home machine,
where I'm having problems. When I run the Query Analyzer, I get an
empty result set for all queries, with the message, "The command(s)
completed successfully." So, for instance, if I were to go to
Northwind and type "SELECT * from Employees", which we KNOW isn't
empty, all I see is "The command(s) completed successfully." How do I
get query results?

I thought maybe the problem was permissions. I'm logged into my local
server, which is the computer on which I'm running. The owner is just
"ZIPPY/Owner", ZIPPY being my machine name; since I'm the only one who
uses the computer, I don't even log in, I just take the default "Owner"
account. I start up the SQL analyzer with Windows credentials.

Anyone have a clue what I'm doing wrong?shelah (shelah2@.verizon.net) writes:
> I am a newbie and have installed SQL Server myself on my home machine,
> where I'm having problems. When I run the Query Analyzer, I get an
> empty result set for all queries, with the message, "The command(s)
> completed successfully." So, for instance, if I were to go to
> Northwind and type "SELECT * from Employees", which we KNOW isn't
> empty, all I see is "The command(s) completed successfully." How do I
> get query results?

You are not even getting an empty result set. Apparently you are in some
sort of noexec mode where the query is sent to SQL Server for validation
only.

There are a couple of ways to get this behaviour. First make sure that
you press the green arrow to run the query. The blue tick is for validation
only.

If the problem is not that simple, check Tools->Options->Connection
properties. If any of SET NOEXEC ON or SET PARSEONLY ON are checked,
uncheck them.

If this does not help, send these commands to SQL Server:

SET PARSEONLY OFF
SET NOEXEC OFF
SET FMTONLY OFF

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thank you, that was an enormous help. You were right; I was clicking
the check and not the green arrow. A great relief to know that I have a
usable database and don't have to do some wierd chown gyrations.

*** Sent via Developersdex http://www.developersdex.com ***|||thanks it was a great help even to me
Erland Sommarskog wrote:
> shelah (shelah2@.verizon.net) writes:
> > I am a newbie and have installed SQL Server myself on my home machine,
> > where I'm having problems. When I run the Query Analyzer, I get an
> > empty result set for all queries, with the message, "The command(s)
> > completed successfully." So, for instance, if I were to go to
> > Northwind and type "SELECT * from Employees", which we KNOW isn't
> > empty, all I see is "The command(s) completed successfully." How do I
> > get query results?
> You are not even getting an empty result set. Apparently you are in some
> sort of noexec mode where the query is sent to SQL Server for validation
> only.
> There are a couple of ways to get this behaviour. First make sure that
> you press the green arrow to run the query. The blue tick is for validation
> only.
> If the problem is not that simple, check Tools->Options->Connection
> properties. If any of SET NOEXEC ON or SET PARSEONLY ON are checked,
> uncheck them.
> If this does not help, send these commands to SQL Server:
> SET PARSEONLY OFF
> SET NOEXEC OFF
> SET FMTONLY OFF
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||To avoid this in the future just hit F5

http://sqlservercode.blogspot.com/