Showing posts with label install. Show all posts
Showing posts with label install. Show all posts

Sunday, March 25, 2012

Clean Install Windows Auth Error

Hi,

I cannot log in to SQL Server 2005 Dev Edition in my local machine using Windows Authentication. The server returned "Login failed..." when connecting with SQL Server Management Studio.

I have not change anything since installation of this server.

This problem happens in RTM and SP1 versions, both running on Windows Vista RTM.

Anyone having this kind of problem too? Any solution? I'm guessing it's Vista-related.

True, this is something of Vista. http://www.microsoft.com/sql/howtobuy/windowsvistasupport.mspx

Sorry for not reading it first.

Tuesday, March 20, 2012

clarification needed on sqlxml installation

I have 2 servers. One is an IIS server and the other is
the SQL Server 2000 SP3 server. I am confused on where i
am supposed to install SQLXML 3.0 SP2. Should i install
the software on the SQL Server machine or the IIS machine?
thanks
In most cases you just need to install it on the IIS Server.
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"Giovanni" <anonymous@.discussions.microsoft.com> wrote in message
news:6ae201c4cb1d$2d894f00$a301280a@.phx.gbl...
I have 2 servers. One is an IIS server and the other is
the SQL Server 2000 SP3 server. I am confused on where i
am supposed to install SQLXML 3.0 SP2. Should i install
the software on the SQL Server machine or the IIS machine?
thanks
|||Now you are making me confused.
Are you sure that you are supposed to install it on the IIS and not the SQL?
What data should the msxisapi.dll file present if not the data from the SQL
server? I have installed the XML service on the SQL server and not the IIS.
Can you explain why you install it on the WEB server and how you configure
it to retrieve data from the SQL server...
Reg
Jrgen Persson
"Graeme Malcolm" <graemem_cm@.hotmail.com> skrev i meddelandet
news:eaeKy97yEHA.336@.TK2MSFTNGP10.phx.gbl...
> In most cases you just need to install it on the IIS Server.
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
>
> "Giovanni" <anonymous@.discussions.microsoft.com> wrote in message
> news:6ae201c4cb1d$2d894f00$a301280a@.phx.gbl...
> I have 2 servers. One is an IIS server and the other is
> the SQL Server 2000 SP3 server. I am confused on where i
> am supposed to install SQLXML 3.0 SP2. Should i install
> the software on the SQL Server machine or the IIS machine?
> thanks
>
|||It depends what you are doing, but SQLXML is primarily a client-side
technology. Install it on the IIS server and use the "Configure IIS Support"
tool to create a VDir that connects to your SQL Server to retrieve the data
you need to expose through IIS (either via a template, a schema, a SOAP
vName).
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"Jrgen" <jorgen_persson78@.hotmail.com> wrote in message
news:%23pNo3H8yEHA.3376@.TK2MSFTNGP12.phx.gbl...
Now you are making me confused.
Are you sure that you are supposed to install it on the IIS and not the SQL?
What data should the msxisapi.dll file present if not the data from the SQL
server? I have installed the XML service on the SQL server and not the IIS.
Can you explain why you install it on the WEB server and how you configure
it to retrieve data from the SQL server...
Reg
Jrgen Persson
"Graeme Malcolm" <graemem_cm@.hotmail.com> skrev i meddelandet
news:eaeKy97yEHA.336@.TK2MSFTNGP10.phx.gbl...
> In most cases you just need to install it on the IIS Server.
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
>
> "Giovanni" <anonymous@.discussions.microsoft.com> wrote in message
> news:6ae201c4cb1d$2d894f00$a301280a@.phx.gbl...
> I have 2 servers. One is an IIS server and the other is
> the SQL Server 2000 SP3 server. I am confused on where i
> am supposed to install SQLXML 3.0 SP2. Should i install
> the software on the SQL Server machine or the IIS machine?
> thanks
>

Sunday, March 11, 2012

Choosing a Licensing Mode

Hello, all. We have a question as to the licensing mode of Reporting
Services for SQL Server 2K. We wish to install according to the following
scheme,
- Report Server: on our web server (ws1)
- Report Manager: on our web server (ws1)
- Report Server Database: on our SQL Server db (sql1)
- Report Designer: on our workstations
Reading what is on this page
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx,
it says that "You must have a valid SQL Server license for each computer
that has a SQL Server 2000 component (such as Reporting Services) installed.
For example, the computer running Reporting Services requires a SQL Server
license. If the report server database is located remotely, a separate
license is required for the remote computer running SQL Server."
Does this mean that we must have a separate SQL Server license for our ws1
machine to be able to run Report Server and Report Manager than the license
we have on our sql1 machine? Thanks in advance :-)The following is general guidance, I'm not an expert on licensing so what I
say definitely does not 'go'. I recommend you speak with your TAM/Sales rep
to ensure you're correctly licensed based on your deployment, hardware, etc.
In general, you need a SQL licence for each computer on which you deploy
server components. Thus, if you deploy report server on computer A and your
SQL engine is on computer B, you need to have a SQL licence for of A and
another for B, totalling 2 processor licenses.
Thyen if you have multi-proc machines, it gets interesting. Speak with
your TAM/Sales rep.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"dw" <cougarmana_NOSPAM@.uncw.edu> wrote in message
news:e9KNnVZbEHA.1644@.tk2msftngp13.phx.gbl...
> Hello, all. We have a question as to the licensing mode of Reporting
> Services for SQL Server 2K. We wish to install according to the following
> scheme,
> - Report Server: on our web server (ws1)
> - Report Manager: on our web server (ws1)
> - Report Server Database: on our SQL Server db (sql1)
> - Report Designer: on our workstations
> Reading what is on this page
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx,
> it says that "You must have a valid SQL Server license for each computer
> that has a SQL Server 2000 component (such as Reporting Services)
> installed.
> For example, the computer running Reporting Services requires a SQL Server
> license. If the report server database is located remotely, a separate
> license is required for the remote computer running SQL Server."
> Does this mean that we must have a separate SQL Server license for our ws1
> machine to be able to run Report Server and Report Manager than the
> license
> we have on our sql1 machine? Thanks in advance :-)
>|||Thanks Lukasz. That's what I was afraid of.
"Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> wrote in message
news:esiORlcbEHA.2340@.TK2MSFTNGP10.phx.gbl...
> The following is general guidance, I'm not an expert on licensing so what
I
> say definitely does not 'go'. I recommend you speak with your TAM/Sales
rep
> to ensure you're correctly licensed based on your deployment, hardware,
etc.
> In general, you need a SQL licence for each computer on which you deploy
> server components. Thus, if you deploy report server on computer A and
your
> SQL engine is on computer B, you need to have a SQL licence for of A and
> another for B, totalling 2 processor licenses.
> Thyen if you have multi-proc machines, it gets interesting. Speak with
> your TAM/Sales rep.
> -Lukasz
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "dw" <cougarmana_NOSPAM@.uncw.edu> wrote in message
> news:e9KNnVZbEHA.1644@.tk2msftngp13.phx.gbl...
> > Hello, all. We have a question as to the licensing mode of Reporting
> > Services for SQL Server 2K. We wish to install according to the
following
> > scheme,
> >
> > - Report Server: on our web server (ws1)
> > - Report Manager: on our web server (ws1)
> > - Report Server Database: on our SQL Server db (sql1)
> > - Report Designer: on our workstations
> >
> > Reading what is on this page
> >
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx,
> > it says that "You must have a valid SQL Server license for each computer
> > that has a SQL Server 2000 component (such as Reporting Services)
> > installed.
> > For example, the computer running Reporting Services requires a SQL
Server
> > license. If the report server database is located remotely, a separate
> > license is required for the remote computer running SQL Server."
> >
> > Does this mean that we must have a separate SQL Server license for our
ws1
> > machine to be able to run Report Server and Report Manager than the
> > license
> > we have on our sql1 machine? Thanks in advance :-)
> >
> >
>

Choose MSDE install location?

I'm trying to install MSDE at c:\Program Files\Microsoft\SQL Server\ (as
opposed to ...\Microsoft SQL Server\).
I tried using the DATADIR= and TARGETDIR= options, but they don't seem to
affect the COM and Tools folders (which always get installed at
...\Microsoft SQL Server\80\). I don't see any other options to set the
location for those two folders.
Am i missing something, or am i stuck with keeping the COM and Tools
directories where they are?
/
hi,
I HATE PDAs wrote:
> I'm trying to install MSDE at c:\Program Files\Microsoft\SQL Server\ (as
> opposed to ...\Microsoft SQL Server\).
> I tried using the DATADIR= and TARGETDIR= options, but they don't
> seem to affect the COM and Tools folders (which always get installed
> at ...\Microsoft SQL Server\80\). I don't see any other options to
> set the location for those two folders.
> Am i missing something, or am i stuck with keeping the COM and Tools
> directories where they are?
you do not have control over a "little" part of the installations... this
with regard to all binaries that will be shared among all available SQL
Server / MSDE 2000 instances... these shared binaries will always be
installed there, and present at the higher service pack level..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply