Connect to remote analisys services 2000?

Hello, my ISP installed analisys services 2000 on the same server they have sql server 2000. They got lots of databases and installed it because I need it.

Anyway with analisys manager I try to regiser the server and I cant.

What do I need to configure on my machine and what else do they need to configure on their server? Do they need to send me some information besides the IP address?

This is the error:

error a conectar a server.dominio.com
no se puede abrir la conexion a server.dominio.com
error de red server.dominio.com

Analysis Services AS2k only works with NT authentication. The only way I know to make this work if your remote workstation and the server are in different domains is to set up matching local users.

Your ISP would need to set up a local user on the server and put that user in the OLAP Administrators group. You would then need to create a local user on your workstation with the same username and password and login using that user (or you might be able to use "Run As..." if you are using WinXP)

You will also need to make sure you have the same Analysis Services service pack on your workstation as is on the server, because Analysis Manager from one service pack often cannot talk to a server with a different service pack.

HTH

Regards
Darren
http://geekswithblogs.net/darrengosbell|||He is right. I get the same problem and this solution help me ;)

Regards,

Thiago
http://www.tritech.com.br

connect to database without server (was "Stupid Newbie Question - sorry in advan

Hi peoples...

I am a total newbie when it comes to SQL databases.

I currently work for a company developing software. We use a VB Development environment and connect to Dbase III database files using DAO... ewwwww...

We are looking to upgrade our development environment to VB.net and our database to either MSSQL or mySQL...

My question is - most of our users are on standalone machines. Our software is NOT internet based, nor do we want it that way at the moment.

Is there a way to connect to a MSSQL database (ie the .mdf file) without having a server running? Or are we better advised to stick to an MS Access database if this is the case...

Basically the reasoning behind upgrading is better speed and record locking. Any advice would be greatly appreciated.

I am sorry to sound so dumb...

Cheers,

KevMicrosoft offers MSDE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdeforvs.asp), the Microsoft Data Engine, which sounds like exactly what you need.

MSDE is a "workstation sized" version of Microsoft SQL Server. It offers a version of the database engine that is limited to 2 Gb per database, and is configured to run on a workstation (so it is missing a few of the really "high end" database features), that is 100% upward compatible with Microsoft SQL Server. It allows the developer to create databases that work on the desktop, can be scaled up to a few users (about 5) without any additional cost to either the developer or the user, and allow easy migration to SQL Server for larger groups of users.

While MSDE may not have the high end features such as clustering, replication management, etc., it IS a full blooded version of SQL Server. From the code perspective, it is almost impossible to tell MSDE from any other version of SQL Server. As your users needs grow, MSDE allows a quick and simple upgrade path to full-blown SQL Server. In almost every case I've seen, MSDE offers the best of both worlds... It is cheap and easy to start with, and can grow to support really large projects when necessary.

-PatP|||Thanks for that... so with MSDE, we would get 1 datafile containing all our tables that wouldn't need any software on the users machine?

Out of interest, what would the file extension be?|||You will need to install MSDE on your machine (and install it with your software), and you get at least two files, an MDF with the actual data and an LDF with the log.

The MSDE software is available to Visual Studio Professional (and above) developers, and a license to distribute it as part of an application that you develop is included with Visual Studio. Think of MSDE as part of the Visual Studio runtime environment.

Check out the link to the article from my previous posting. I think that article gives the "30,000 foot view" of MSDE and the distribution model. The whole process really isn't very complex, although you need to think on a bit broader scale than you did with dBase files. Once you make the jump, you'll never want to go back!

-PatP|||I have just tried installing MSDE - when I double click the setup file, it says it can't install because I don't have a "strongpassword" on SAPWD... I go to the knowledgebase article they reference for help on this and do what is says, it says to enter oSQL -U sa at the command prompt and it says oSQL isn't recognised as internal or external command etc etc...

I hate Microsoft.. I truly do|||Check here (http://support.microsoft.com/default.aspx?scid=kb;en-us;814463) for help with strong sa passwords from within code. As a general rule of thumb, just use a license plate or pick a sentence that you'll remember and take the first or last letter from each word to make a strong password.

-PatP|||Hi again Pat...

Ok, I am running windows xp professional... I have downloaded the MSDE file and doubleclicked setup... when I do, it comes up with an error... that link you gave me was about setting with password once it has been installed... from what I could see anyway..|||Hi,
What is the error message? And one more information, at default when u install .NET there is a option to install MSDB (stand alone database). Have u installed .NET?|||No, I have not installed .net.

I am still running VB6 as my development environment... I want to test the options available to me before I make my final decision.sqlsql

Connect to Database in SQL 2005 Express

I am trying to connect to the sample databases in SQL Express. I am getting this error.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Name Pipes Provider, error: 40 - could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

I have downloaded and installed AdventureWorks, Northwind, and Pubs. If I have to allow remote connections how do I do that? I am a studen and I am brand new at this.

first ensure the sample database you wish to use is registered (some of the samples must first be attached from the D/L .mdf files).

second startup the SURFACE AREA CONFIG TOOL via the start menu. after the splash screen display click on the configure services and connections link.

select the Remote Connection node in the tree and select the second radio button to enable remote connections.

if you still have problems you should look at the protocols your sql server has enabled and which protocol format you are using to connect.

|||

1. Open SQL Server Configuration Manager under "Microsoft SQL Sever 2005" "Configuration Tools"

2. Navigate to "Sql Server 2005 Network Configuration" --"Protocols for SQL2005"

3. Enable "Shared Memory" , "Named Pipes" & "TCP/IP"

This should solve the problem

|||I figured it out. I feel stupid now. I just had to right click on database and click attach. Then click add. This brought me out to the windows hierarchy where I was able to find the Northwind database and click on it to add it.|||

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Name Pipes Provider, error: 40 - could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

Connect to Database in SQL 2005 Express

I am trying to connect to the sample databases in SQL Express. I am getting this error.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Name Pipes Provider, error: 40 - could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

I have downloaded and installed AdventureWorks, Northwind, and Pubs. If I have to allow remote connections how do I do that? I am a studen and I am brand new at this.

first ensure the sample database you wish to use is registered (some of the samples must first be attached from the D/L .mdf files).

second startup the SURFACE AREA CONFIG TOOL via the start menu. after the splash screen display click on the configure services and connections link.

select the Remote Connection node in the tree and select the second radio button to enable remote connections.

if you still have problems you should look at the protocols your sql server has enabled and which protocol format you are using to connect.

|||

1. Open SQL Server Configuration Manager under "Microsoft SQL Sever 2005" "Configuration Tools"

2. Navigate to "Sql Server 2005 Network Configuration" --"Protocols for SQL2005"

3. Enable "Shared Memory" , "Named Pipes" & "TCP/IP"

This should solve the problem

|||I figured it out. I feel stupid now. I just had to right click on database and click attach. Then click add. This brought me out to the windows hierarchy where I was able to find the Northwind database and click on it to add it.|||

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Name Pipes Provider, error: 40 - could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

Connect to Client SQL

We happily connect to a couple of SQL databases on ISP servers using our
Enterprise Manager. We now have a client who wants us to connect to his
local SQL server in the same manner and I can't make it work.
I have 1433 open all the way through the various firewalls etc. Is there
any other port concerned that I might have to open up on his router as I try
and come in?
Many thanks
AndrewIf it's a default instance, listening on the default port, yes it should
work. Are you sure name resolution is working? In other words, you might
try to connect to his IP Address, i.e. "131.107.x.x,1433" as the
servername...
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Prior" <andrew@.not-accede.com.au> wrote in message
news:u1QOcCFwDHA.1760@.TK2MSFTNGP10.phx.gbl...

quote:

---

> We happily connect to a couple of SQL databases on ISP servers using our
> Enterprise Manager. We now have a client who wants us to connect to his
> local SQL server in the same manner and I can't make it work.
> I have 1433 open all the way through the various firewalls etc. Is there
> any other port concerned that I might have to open up on his router as I

---

try

quote:

---

> and come in?
> Many thanks
> Andrew
>

---

|||Thankyou Richard. Yes, names are resolved. I have 1433 open all the way...
my port scanner can see it no worries.
I've never set up a server off my own network for an external user to log
into, so I am worried I am missing something here. His server is set up for
mixed mode logon. Is there anything else different that would apply to a
non local user?
Thankyou for your time
Andrew
I'm wondering if the firewall is stopping something else
"Richard Waymire [MSFT]" <rwaymi@.online.microsoft.com> wrote in message
news:Oa1NuxGwDHA.3744@.TK2MSFTNGP11.phx.gbl...

quote:

---

> If it's a default instance, listening on the default port, yes it should
> work. Are you sure name resolution is working? In other words, you might
> try to connect to his IP Address, i.e. "131.107.x.x,1433" as the
> servername...
> --
> Richard Waymire, MCSE, MCDBA
> This posting is provided "AS IS" with no warranties, and confers no

---

rights.

quote:

---

> "Andrew Prior" <andrew@.not-accede.com.au> wrote in message
> news:u1QOcCFwDHA.1760@.TK2MSFTNGP10.phx.gbl...
there[QUOTE]
> try
>

---

|||is the connection they're attempting standard or windows authentication?
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Prior" <andrew@.not-accede.com.au> wrote in message
news:uk1pfGswDHA.3116@.tk2msftngp13.phx.gbl...

quote:

---

> Thankyou Richard. Yes, names are resolved. I have 1433 open all the

---

way...

quote:

---

> my port scanner can see it no worries.
> I've never set up a server off my own network for an external user to log
> into, so I am worried I am missing something here. His server is set up

---

for

quote:

---

> mixed mode logon. Is there anything else different that would apply to a
> non local user?
> Thankyou for your time
> Andrew
> I'm wondering if the firewall is stopping something else
> "Richard Waymire [MSFT]" <rwaymi@.online.microsoft.com> wrote in message
> news:Oa1NuxGwDHA.3744@.TK2MSFTNGP11.phx.gbl...
might[QUOTE]
> rights.
our[QUOTE]
his[QUOTE]
> there
I[QUOTE]
>

---

connect more than one database in a query

How can I access tables from different databases in the same server in a
query or stored procedure.
Also how to access databases existing in different database servers.
Thanks fro your help.
Retna
Hi,
To access the tables in the databases in same server you can use the below
syntax.
select * from dbname.tableowner.table_name
To access the table in in differenet server u need to create linked server.
AFter that you could use
select * from linkedservername.dbname.tableowner.table_name
See the below article on how to create linked server and execute DML
comamnds.
http://www.microsoft.com/India/msdn/articles/166.aspx
Thanks
Hari
MCDBA
"Retna" <Retna@.discussions.microsoft.com> wrote in message
news:04CD4FE1-0A0F-466C-9EBC-0AEBE55440A8@.microsoft.com...
> How can I access tables from different databases in the same server in a
> query or stored procedure.
> Also how to access databases existing in different database servers.
> Thanks fro your help.
> Retna
|||Thanks Hari for your valuable and timely reply .
Retna
"Hari Prasad" wrote:

> Hi,
> To access the tables in the databases in same server you can use the below
> syntax.
> select * from dbname.tableowner.table_name
> To access the table in in differenet server u need to create linked server.
> AFter that you could use
> select * from linkedservername.dbname.tableowner.table_name
> See the below article on how to create linked server and execute DML
> comamnds.
> http://www.microsoft.com/India/msdn/articles/166.aspx
> Thanks
> Hari
> MCDBA
>
> "Retna" <Retna@.discussions.microsoft.com> wrote in message
> news:04CD4FE1-0A0F-466C-9EBC-0AEBE55440A8@.microsoft.com...
>
>

connect more than one database in a query

How can I access tables from different databases in the same server in a
query or stored procedure.
Also how to access databases existing in different database servers.
Thanks fro your help.
RetnaHi,
To access the tables in the databases in same server you can use the below
syntax.
select * from dbname.tableowner.table_name
To access the table in in differenet server u need to create linked server.
AFter that you could use
select * from linkedservername.dbname.tableowner.table_name
See the below article on how to create linked server and execute DML
comamnds.
http://www.microsoft.com/India/msdn/articles/166.aspx
Thanks
Hari
MCDBA
"Retna" <Retna@.discussions.microsoft.com> wrote in message
news:04CD4FE1-0A0F-466C-9EBC-0AEBE55440A8@.microsoft.com...
> How can I access tables from different databases in the same server in a
> query or stored procedure.
> Also how to access databases existing in different database servers.
> Thanks fro your help.
> Retna|||Thanks Hari for your valuable and timely reply .
Retna
"Hari Prasad" wrote:
> Hi,
> To access the tables in the databases in same server you can use the below
> syntax.
> select * from dbname.tableowner.table_name
> To access the table in in differenet server u need to create linked server.
> AFter that you could use
> select * from linkedservername.dbname.tableowner.table_name
> See the below article on how to create linked server and execute DML
> comamnds.
> http://www.microsoft.com/India/msdn/articles/166.aspx
> Thanks
> Hari
> MCDBA
>
> "Retna" <Retna@.discussions.microsoft.com> wrote in message
> news:04CD4FE1-0A0F-466C-9EBC-0AEBE55440A8@.microsoft.com...
> > How can I access tables from different databases in the same server in a
> > query or stored procedure.
> > Also how to access databases existing in different database servers.
> >
> > Thanks fro your help.
> >
> > Retna
>
>

Connect from Databases in 1st Instance to Databases in 2nd Instance

This is the scenario. Is it possible to create views or something (like Oracle DB Links) in a database in Instance 1 which can show data from another database in 2nd Instance ?
I want to do this to create reports.you want to create a linked server with sp_addlinkedserver|||thanks. it worked.

Connect 2 databases on 2 servers ??

Hi,

If you have 2 databases with the exact same table columns, and in the first database in a table column the indentidy seed starts at 1 and finishes at 32,000 can you attatch a second database so that the indentity starts at 32,001and carries on.

What happens if you create a site and run out of disk space and need to attach another database which is located on another server?

I am really confused about this.Hope someone can give some links to some articles about this as I can't find any information about it.

How can this be done?

Thanks

robinwilliams:

If you have 2 databases with the exact same table columns, and in the first database in a table column the indentidy seed starts at 1 and finishes at 32,000 can you attatch a second database so that the indentity starts at 32,001and carries on.

Yes, you can!
Just use DTS (in SQL Server 2000) or SSIS (in SQL Server 2005) and while trasfering the data select the "Append Data" option, but make sure the data type of the identity column in the source table is able to deal with new records (have enough size) [e.g. make it INT].

robinwilliams:

What happens if you create a site and run out of disk space and need to attach another database which is located on another server?

What do you mean by another server? Is it physically another server (e.g. using another disk)? If yes, the database files (.mdf, .ndf, .ldf) will be in that server using its disks which are diffrent than the ones have no enough space.
Once you are runing out of space, you will receive error indicating that (e.g. in Enterpise Manager or Management Studio), So always have more space than you need by 2-4GB at least.

Good luck.

Conlidate databases for multiple installations

1. install a SQL Express instance such as myexpress;

2. create some databases with tables such as db1 and db2;

3. Reinstall SQL Express with the same instance name "myexpress". I assume we need reinstall SQL Express myexpress again becuase of bad operations.

4. Open the myexpress by management tool but I can not see db1 and db2 databases but the datafiles and logfiles are in the data directory.

The question is what I need to do so I can consolidate exited databases so they can be seen in "myexpress" instance by management tool?

Hmmm it seems it has nothing to do with Team System, I would recommend you to ask this in the SQL Server forums, in which you will get more help for sure, sorry and good luck.

I also think the step you are not doing is an attach of the databases.

Confused

I have VB. NET
I want to build SQL databases on my own PC using VB and
MSDE.
No matter how many ways I install it or passwords I use,
I just cannot get read/write access from witihn VB. I
have upsized the Northwind.mdb.
There seems to be a multidude or service packs for MSDE
and numerous ways of entering passwords.
Could osmeone please just give me a setp by step account
of installing MSDE (with all relevant switches and
passwords), getting a SQL instance on MSDE running and
visible on the manager, upsizing the access database
(with all relevant passwords - what the hell is a trusted
connection?), and then be able to create a view from the
Server Explorer in .NET.
I've been slaving over this for the past two days and
it's driving me nuts. Please help maintain my sanity.
Thanks
Guy
hi Guy,
"Guy" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:0ae801c4d89a$9e2c19b0$a401280a@.phx.gbl
> I have VB. NET
> I want to build SQL databases on my own PC using VB and
> MSDE.
> No matter how many ways I install it or passwords I use,
> I just cannot get read/write access from witihn VB. I
> have upsized the Northwind.mdb.
> There seems to be a multidude or service packs for MSDE
> and numerous ways of entering passwords.
> Could osmeone please just give me a setp by step account
> of installing MSDE (with all relevant switches and
> passwords), getting a SQL instance on MSDE running and
> visible on the manager, upsizing the access database
> (with all relevant passwords - what the hell is a trusted
> connection?), and then be able to create a view from the
> Server Explorer in .NET.
> I've been slaving over this for the past two days and
> it's driving me nuts. Please help maintain my sanity.
in order to create new objects the Windows NT login you are using when
connecting with trusted authentication must be member of the ddl_admin fixed
database role, please have a look at
http://msdn.microsoft.com/library/de...urity_6ndx.asp
for further info
as about authentication, I do think you have to understand the security
approach of SQL Server, and you can start reading at
http://msdn.microsoft.com/library/de...urity_47u6.asp
this is the first phase of the 2 levels security system of SQL Server...
again, the 1st phase is validating login to the server..
the second phase regards a database security implementation... in order to
access a specified database the simple login existance does not provide
database access, but a (database) user must be mapped to the corresponding
login (this is done on the basis of a join between the MyDb..sysusers.sid =
master..syslogins.sid )..
the 2nd phase is about verifying that at each object level (including
database, tables, views, columns, procedures and so on) the Login/User
association is permitted access to... please go on reading at
http://msdn.microsoft.com/library/de...ar_da_0n77.asp
and following chapters..
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

Conflict with logins/usres when Importing databases

Hi,

We have imported several databases from an old SQL Server 2000 deployment in a SQL Server 2005 instance. After the installations we have check that the import doesn't create the logins associated with the users nad now it seems impossible to create "manually" the login. What should be do? Re-import the database after having created the login?

Thanks
You should still be able to create the login using CREATE LOGIN and then run the system proc
sp_change_users_login to map the existing users to the newly created login.

Reimporting the database will probably not work as the SIDs of the new logins will not match those of the old logins.

HTH.
|||Effectively, we have been able to create the login but we are unable to associate it to the user using the the "User Properties". The field "Login" appears empty and disabled, so there is no way to assign a user from this screen.

Reading your answer I understand that I can map the users to the newly created logins using the sp_change_users_login function. It's true? Could you send me a sample of use of this function? How should we execute it? (We are SQL Server newbies coming from Oracle world......)+

Thanks
|||

I assume you imported only your user-database probably using import wizard or something. Security information (users and logins) is stored in 'master' database in SQL Server world. You have to transfer these information from your old database to new one.

Check this out.

How to transfer logins and passwords between instances of SQL Server

http://support.microsoft.com/kb/246133/en-us

|||sample:

sp_change_users_login 'AUTO_FIX', 'some_login'

|||Check the information in Books Online which will give you a full explanation of the options open to you:

http://msdn2.microsoft.com/en-us/library/ms174378.aspx

Essentially to map an existing user Bob to a new login of Bob you're looking at running:

sp_change_users_login 'Update_One', 'Bob', 'Bob';

Hope this helps;

Conflict in equal-to-operation

Hi there,

I am trying to update one table on server A/database A with new records from a server B/database B.

Both databases use the same collation. The key-fields of both table do use the same collation, but not the server.

Help: I was thinking, when both databases and the fields inside the tables do both use the same collation, then there will not upcome any conflict ?

Do I have to adapt the database collation, too ? This would'nt be nice as I am retreiving data from different servers with different server collations...
Anybody else got the same problem ?

Thx in advance

dajmI would imagine as long as the 2 fields have the same collation you would be alright because that would override both the db and server collations.|||I would imagine as long as the 2 fields have the same collation you would be alright because that would override both the db and server collations.

Hmm, I would have imagined the same, but it isn't. I re-created the tables, but get the same error. Collation is on <database default> on both fields and this is exactly the same...
:eek:

dajm

Configuring SQL server express for VWD

For some reason I can't seem to be able to add SQL databases to VWD

I receive the following error message:

Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251

I have reinstalled SQL server but I still have the same problem, I tried tweaking some of the Server configurations without success.

I searched for hours on the web for answers but couldn't find any.

If anyone has any idea what could be the problem please help me.

My OS is Windows XP Professional SP2
IIS is installed.

Do you have SQL Server Remote connections enabled on your machine ? Can you in addition post your connection string you are using.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Yes remote connections are allowed, configured in the Surface Area Configuration.

I'm able to connect to a database I've created with Management Studio. But i can't create databases in VWD.

Code Snippet

connectionString="Data Source=DENNIS;Initial Catalog=Inventaris;Integrated Security=True"

This is the one I use for an existing database.

I forgot to mention that both SQL Server express and VWD run on the same computer.

|||

That wonders me a bit, you error is stating that you are trying to connect to a userinstance, your connection string uses a server instance. Could it be that you are using a different connection string than you think ;-) ? This error message comes if you are either using a SQL Server Express instance which is not enabled for user instances or you use a "bigger" instance than SQL Server Express.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||When I use add connection in the database explorer I can chose the "Microsoft SQL Server" option and it works so long as the database exists.
But if I use the "Microsoft SQL Server Database File (SQLClient)" option and browse to an existing database or try to create a new one, it doesn't work and produces an error saying that the SQL server probably doesn't allow remote connections. Although I'm pretty sure it does.

I also allowed userinstances with the use of a query in Management Studio.

|||

Having a SQLServer Express instance you will have to name it in the connection using the following syntax:

connectionString=@."Data Source=DENNIS\SqlExpress;Initial Catalog=Inventaris;Integrated Security=True"

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||After changing DENNIS (the server name) to 127.0.0.1 it works.

I guess when running the server local this is required.

Thanks for your help and quick responses.

Configuring SQL 2000 for use with ESRI ArcSDE

Rookie here....
I need help making some changes so that security is enabled on the ESRI
side. My problem is this. I have Two databases (SDE and Vector) 3 Roles
(Viewer, Editor 1 and Editor 2) and multiple users/logins. I can not find
any documentation which specifies how I assigne users to roles. In addition,
I can not find out which users in which databases should have Create Table,
Create Function Create SP, etc...
Any one have any good resources I can look at?
You can assign SQL Server users to database roles using sp_addrolemember:
USE SDE
EXEC sp_addrolemember 'Viewer', 'SomeUser'
GO
Permissions are entirely application specific. I assume these roles are
pre-defined by the app and appropriate object permissions assigned. Your
application documentation should specify if any additional permissions (e.g.
CREATE) are needed by application users. If the app doc doesn't contain
this information and you have security issues, I suggest to contact the
vendor for clarification of security requirements. You might get lucky with
a knowledgeable ESRI user in this forum but your vendor is the authoritative
source.
Hope this helps.
Dan Guzman
SQL Server MVP
"Joe16" <Joe16@.discussions.microsoft.com> wrote in message
news:D0F741EF-8DAA-4630-A6EA-49564330B345@.microsoft.com...
> Rookie here....
> I need help making some changes so that security is enabled on the ESRI
> side. My problem is this. I have Two databases (SDE and Vector) 3 Roles
> (Viewer, Editor 1 and Editor 2) and multiple users/logins. I can not find
> any documentation which specifies how I assigne users to roles. In
> addition,
> I can not find out which users in which databases should have Create
> Table,
> Create Function Create SP, etc...
> Any one have any good resources I can look at?
>

configuring Active/Active...

My Current configuration is:
Windows 2003, cluster service, SQL 2000 sp3
I have 3 databases I want to run one in the cluster node1 and the other two
databases in the node2.
So, when node1 fail, node2 take the node1 DB and vice-versa.
Is possible? do you know some URL where I can find information about it?
Another question: In the Active/Active my applications always make a
connection to the Virtual Server or to each Instance?
Thanks
AA
Yes, this is possible. You will need separate physical disks for each
installation of SQL. Each instance corresponds to a virtual server so the
SQL connection is to the IP of the virtual server and the port of the
instance. Since each instance is on a separate IP address, you can have all
instances using the same port number. All that is required to create a
second installation is to run the SQL install agaon and create a new
clustered instance using new resources (disks, network name, IP address).
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"AA" <aa@.personal.net.py> wrote in message
news:e93uK5UdEHA.3732@.TK2MSFTNGP11.phx.gbl...
> My Current configuration is:
> Windows 2003, cluster service, SQL 2000 sp3
> I have 3 databases I want to run one in the cluster node1 and the other
two
> databases in the node2.
> So, when node1 fail, node2 take the node1 DB and vice-versa.
> Is possible? do you know some URL where I can find information about it?
>
> Another question: In the Active/Active my applications always make a
> connection to the Virtual Server or to each Instance?
>
> Thanks
> AA
>

configuring a database in sqlserver?

I am learning dotnet thru Microsoft Official Curriculum and I got stuck up at one point. That is I couldn't configure the required databases according to the sql server I have installed and configured. I created a doctors database and while configuring using the below code I couldn't know what is '\ASPNET' in "SELECT @.s = @.@.servername + '\ASPNET'"
Also what is 'webuser'

Configure Doctors
USE doctors

GO

DECLARE @.s varchar(50)
SELECT @.s = @.@.servername + '\ASPNET'
EXECUTE sp_grantlogin @.s

EXECUTE sp_grantdbaccess @.s, 'webuser'

GO

GRANT EXECUTE ON [getUniqueCities] TO webuser
GRANT EXECUTE ON [getDrSpecialty] TO webuser

GRANT SELECT ON [specialties] TO webuser
GRANT SELECT ON [doctors] TO webuser
GRANT SELECT ON [drspecialties] TO webuser

GO

Can anyone help me how to solve my problem?
Your help would be very much appreciated

Thanks and Regards

Kavitha

Probably best to consult the TSQL forum.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=85&SiteID=1

Configuring 2 nodes as failovers for each other

We have a number of databases in our company and we recently had to buy a second SQL server.What I would like to do is have both SQL Servers act as failovers for each other.They both are the exact same hardware configuration (dell blades poweredge 1855) and we have a RAID array with Melio clustered file system for our web servers.I haven’t found any documentation on if this is even possible.Am I completely wrong in thinking this can be done or is there a better solution to spread the load but provide failover support with out buying 2 new machines?

Basic cluster 'failover' schemes require 'shared storage', such as SAN or NAS. If the disk array is dedicated to only one machine, it is not shared storage.

You might be better off examining Server Mirroring (if you are using SQL 2005).

Configure Report Server - SharePoint Integration

Hello,

I'm trying to set up SharePoint Integration for our report server. The setup we have is: 1. SQL server hosting the SharePoint databases and the Reporting Server, 2. SharePoint web front end hosting all SharePoint services. I've installed the reporting services SP2 on the SQL server and the reporting services add-in on the SharePoint server.

I configured the report server following the directions here: http://download.microsoft.com/download/f/d/c/fdcb3a53-0cb1-4e67-a1b6-45b89b3c59cf/readme_rsaddin.htm and here: http://www.sharepointblogs.com/helloitsliam/archive/2007/02/21/19801.aspx

Everything seems to be set up correctly, but when I open the Reporting Services Configuration Manager, the SharePoint Integration option shows the error, "The report server cannot access setting in the SharePoint configuration database. Most likely, the Windows SharePoint Services object model...."

I do have WSS 3.0 installed on the report server.

When I look in the logs on the report server it says the login failed for the account I have set as the Windows Service Identity however, when I look at the logs on the SharePoint server it shows that it is granting the account read and write access to each of the SPWebApplications I have set up.

Any suggestions?

Thanks,

Cynthia

I just figured it out. It always happens that after days of unsuccessful attempts, I figure out the problem as soon as I post to a forum.

In case anyone else has the same problem:

In the Reporting Services Configuration Manager, under Windows Service Identity, I re-entered the name and password of the account and this caused a new dialog box to open prompting me to create an encryption key back-up. I provided a password and file location and then it worked. I'm not sure why I didn't get that dialog box initially, but everything works fine now.

Thanks,

Cynthia

|||

Hi

Can you people please confirm me that

Is that SQL Reporting Services 2005 can only be integrated with MOSS but not WSS 3.0

I am using wss3.0 (Not MOSS) and SQL reporting services 2005.

Configuration steps completed but i am not able to see the Reporting Services section in Application management

of Central Administration.

I installed SQL SP2 and Reporting Services Add ins and everything is on one system, i mean SQL2005 and wss3.0 on one system

I could use SQL Report configuration tool and set all the properties but not able to find Reporting Services section in Application management

of Central Administration.

Please Advice

Thanks,

Tiger

|||

Yes i got the solution for this

We need to Activate the Reporting services in the Central Administration this can be done by the following steps

1. Go to Site settings

2.In the Site collection Administration navigate to Site collection Features

3. Enable the Settings for Reporting Sevices

This will dispay the Reporting Section in the Application Management of Central Administration

Hope this will be help full.

Many Thanks,

Tiger

Configure SQL Server for application services

While using aspnet_regsql.exe to configure SQL Server for application services, the following error pops up: Failed to query a list of databases names from the SQLserver. Cannot initilaize SSPI package". The page is "Select the Server and Database". Please advise. Thanks.

First, check out the time synchronization between your client machine and the database server. Some SSPI issue may be raised if there is a large time disparity.

You can also check this KB to see whether it helps:

http://support.microsoft.com/kb/253577/

If this doesn't work, you may need to learn something more complex about troubleshooting SSPI issues:

http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp

http://support.microsoft.com/kb/811889/