If this is a Linked Server issue I would try the SQL Server Engine forum.
Donald
Showing posts with label unable. Show all posts
Showing posts with label unable. Show all posts
Friday, March 30, 2012
Problems Linking to Oracle Server
Has anyone successfully linked to an Linux Oracle server running 9i? We are unable to get the link working.....have installe dvarious drivers and still get connection refused. Any thoughts?
Friday, March 23, 2012
Problems converting Access UNION query to SQL
I've got a Union query that works in Access but I'm unable to get it to work
querying a SQL Server. Access was using linked tables so the data was
really coming from SQL anyway. I want to make this query work within
Reporting Services, but I'm receiving the following error message:
ADO error: ORDER BY items must appear in the select list if the statement
contains a UNION operator.
I was able to take the two Select statements from Access and make good SQL
queries with them, but I'm unable to UNION them together eventhough it works
fine in Access. Here's my two queries I'm trying to Union:
SELECT TOP 100 PERCENT dbo.SOP30200.SLPRSNID, dbo.SOP30200.DOCAMNT
FROM dbo.SOP30200 LEFT OUTER JOIN
dbo.RM00101 ON dbo.SOP30200.CUSTNMBR =
dbo.RM00101.CUSTNMBR
WHERE (dbo.SOP30200.DOCDATE >= CONVERT(DATETIME, '2006-02-15 00:00:00',
102)) AND (dbo.SOP30200.DOCDATE <= '2006-03-01') AND
(dbo.SOP30200.SOPTYPE = 3) AND (dbo.SOP30200.VOIDSTTS
= 0) AND (dbo.SOP30200.DOCID = 'inv')
ORDER BY dbo.SOP30200.SLPRSNID, dbo.SOP30200.CUSTNMBR
UNION
SELECT dbo.SOP30200.SLPRSNID, - (1 * dbo.SOP30200.DOCAMNT) AS expReturns
FROM dbo.SOP30200 LEFT OUTER JOIN
dbo.RM00101 ON dbo.SOP30200.CUSTNMBR =
dbo.RM00101.CUSTNMBR LEFT OUTER JOIN
dbo.viewSalesperson ON dbo.RM00101.SLPRSNID =
dbo.viewSalesperson.SLPRSNID
WHERE (dbo.SOP30200.DOCDATE >= CONVERT(DATETIME, '2006-02-15 00:00:00',
102)) AND (dbo.SOP30200.DOCDATE <= CONVERT(DATETIME,
'2006-03-01 00:00:00', 102)) AND
(dbo.SOP30200.VOIDSTTS = 0) AND (dbo.SOP30200.SOPTYPE = 4) AND
(dbo.SOP30200.DOCID = 'returns')order by of the first part of the union should be the problem.
Colin wrote:
>I've got a Union query that works in Access but I'm unable to get it to wor
k
>querying a SQL Server. Access was using linked tables so the data was
>really coming from SQL anyway. I want to make this query work within
>Reporting Services, but I'm receiving the following error message:
>ADO error: ORDER BY items must appear in the select list if the statement
>contains a UNION operator.
>I was able to take the two Select statements from Access and make good SQL
>queries with them, but I'm unable to UNION them together eventhough it work
s
>fine in Access. Here's my two queries I'm trying to Union:
>SELECT TOP 100 PERCENT dbo.SOP30200.SLPRSNID, dbo.SOP30200.DOCAMNT
>FROM dbo.SOP30200 LEFT OUTER JOIN
> dbo.RM00101 ON dbo.SOP30200.CUSTNMBR =
>dbo.RM00101.CUSTNMBR
>WHERE (dbo.SOP30200.DOCDATE >= CONVERT(DATETIME, '2006-02-15 00:00:00',
>102)) AND (dbo.SOP30200.DOCDATE <= '2006-03-01') AND
> (dbo.SOP30200.SOPTYPE = 3) AND (dbo.SOP30200.VOIDSTTS
>= 0) AND (dbo.SOP30200.DOCID = 'inv')
>ORDER BY dbo.SOP30200.SLPRSNID, dbo.SOP30200.CUSTNMBR
>UNION
>SELECT dbo.SOP30200.SLPRSNID, - (1 * dbo.SOP30200.DOCAMNT) AS expReturn
s
>FROM dbo.SOP30200 LEFT OUTER JOIN
> dbo.RM00101 ON dbo.SOP30200.CUSTNMBR =
>dbo.RM00101.CUSTNMBR LEFT OUTER JOIN
> dbo.viewSalesperson ON dbo.RM00101.SLPRSNID =
>dbo.viewSalesperson.SLPRSNID
>WHERE (dbo.SOP30200.DOCDATE >= CONVERT(DATETIME, '2006-02-15 00:00:00',
>102)) AND (dbo.SOP30200.DOCDATE <= CONVERT(DATETIME,
> '2006-03-01 00:00:00', 102)) AND
>(dbo.SOP30200.VOIDSTTS = 0) AND (dbo.SOP30200.SOPTYPE = 4) AND
>(dbo.SOP30200.DOCID = 'returns')
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200603/1|||Any suggestions on what I need to do to fix it?
"psychodad71 via webservertalk.com" <u2248@.uwe> wrote in message
news:5cf4869c57190@.uwe...
> order by of the first part of the union should be the problem.
> Colin wrote:
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...amming/200603/1|||Syntax is:
SELECT ... FROM ...
UNION (ALL)
SELECT ... FROM ...
ORDER BY...
(I also wonder why a TOP 100 PERCENT. That should return everything and
requires an ORDER BY to work. Get rid of the TOP 100 PERCENT> )
RLF
"Colin" <legendsfan@.nospam.nospam> wrote in message
news:etPkz6sQGHA.5924@.TK2MSFTNGP09.phx.gbl...
> Any suggestions on what I need to do to fix it?
> "psychodad71 via webservertalk.com" <u2248@.uwe> wrote in message
> news:5cf4869c57190@.uwe...
>|||Thanks for the help and feedback. I've got it working now. Is there a
reason why Visual Studio or any other design interface doesn't support
Design mode for UNION of two queries?
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:uWwHb5uQGHA.2816@.TK2MSFTNGP15.phx.gbl...
> Syntax is:
> SELECT ... FROM ...
> UNION (ALL)
> SELECT ... FROM ...
> ORDER BY...
> (I also wonder why a TOP 100 PERCENT. That should return everything and
> requires an ORDER BY to work. Get rid of the TOP 100 PERCENT> )
> RLF
> "Colin" <legendsfan@.nospam.nospam> wrote in message
> news:etPkz6sQGHA.5924@.TK2MSFTNGP09.phx.gbl...
>|||A few notes that may help you (and others):
1. TOP 100 Percent ... ORDER BY was a workaround/hack/creative piece of SQL
to try to get the optimizer to sort values at a point in the query plan.
Unfortunately, it didn't really work in all cases, and it actually isn't
being honored at all in SQL 2005. So, please consider removing this from
your code in the future.
2. As you've seen from the other posts, ORDER BY should be applied to the
end of the complete statement to affect the presentation order of the
results returned to the client (and not each block of the UNION).
3. The column binding rules for Jet Red (Access's engine) never really
conformed to the ANSI standards. Given the installed base, it's not likely
to be changed. So, just be aware that the queries you may have in your
Access application are sometimes interpreted in slightly different ways.
Best of luck,
Conor Cunningham
SQL Server Query Optimization Development Lead
"Colin" <legendsfan@.nospam.nospam> wrote in message
news:etPkz6sQGHA.5924@.TK2MSFTNGP09.phx.gbl...
> Any suggestions on what I need to do to fix it?
> "psychodad71 via webservertalk.com" <u2248@.uwe> wrote in message
> news:5cf4869c57190@.uwe...
>
querying a SQL Server. Access was using linked tables so the data was
really coming from SQL anyway. I want to make this query work within
Reporting Services, but I'm receiving the following error message:
ADO error: ORDER BY items must appear in the select list if the statement
contains a UNION operator.
I was able to take the two Select statements from Access and make good SQL
queries with them, but I'm unable to UNION them together eventhough it works
fine in Access. Here's my two queries I'm trying to Union:
SELECT TOP 100 PERCENT dbo.SOP30200.SLPRSNID, dbo.SOP30200.DOCAMNT
FROM dbo.SOP30200 LEFT OUTER JOIN
dbo.RM00101 ON dbo.SOP30200.CUSTNMBR =
dbo.RM00101.CUSTNMBR
WHERE (dbo.SOP30200.DOCDATE >= CONVERT(DATETIME, '2006-02-15 00:00:00',
102)) AND (dbo.SOP30200.DOCDATE <= '2006-03-01') AND
(dbo.SOP30200.SOPTYPE = 3) AND (dbo.SOP30200.VOIDSTTS
= 0) AND (dbo.SOP30200.DOCID = 'inv')
ORDER BY dbo.SOP30200.SLPRSNID, dbo.SOP30200.CUSTNMBR
UNION
SELECT dbo.SOP30200.SLPRSNID, - (1 * dbo.SOP30200.DOCAMNT) AS expReturns
FROM dbo.SOP30200 LEFT OUTER JOIN
dbo.RM00101 ON dbo.SOP30200.CUSTNMBR =
dbo.RM00101.CUSTNMBR LEFT OUTER JOIN
dbo.viewSalesperson ON dbo.RM00101.SLPRSNID =
dbo.viewSalesperson.SLPRSNID
WHERE (dbo.SOP30200.DOCDATE >= CONVERT(DATETIME, '2006-02-15 00:00:00',
102)) AND (dbo.SOP30200.DOCDATE <= CONVERT(DATETIME,
'2006-03-01 00:00:00', 102)) AND
(dbo.SOP30200.VOIDSTTS = 0) AND (dbo.SOP30200.SOPTYPE = 4) AND
(dbo.SOP30200.DOCID = 'returns')order by of the first part of the union should be the problem.
Colin wrote:
>I've got a Union query that works in Access but I'm unable to get it to wor
k
>querying a SQL Server. Access was using linked tables so the data was
>really coming from SQL anyway. I want to make this query work within
>Reporting Services, but I'm receiving the following error message:
>ADO error: ORDER BY items must appear in the select list if the statement
>contains a UNION operator.
>I was able to take the two Select statements from Access and make good SQL
>queries with them, but I'm unable to UNION them together eventhough it work
s
>fine in Access. Here's my two queries I'm trying to Union:
>SELECT TOP 100 PERCENT dbo.SOP30200.SLPRSNID, dbo.SOP30200.DOCAMNT
>FROM dbo.SOP30200 LEFT OUTER JOIN
> dbo.RM00101 ON dbo.SOP30200.CUSTNMBR =
>dbo.RM00101.CUSTNMBR
>WHERE (dbo.SOP30200.DOCDATE >= CONVERT(DATETIME, '2006-02-15 00:00:00',
>102)) AND (dbo.SOP30200.DOCDATE <= '2006-03-01') AND
> (dbo.SOP30200.SOPTYPE = 3) AND (dbo.SOP30200.VOIDSTTS
>= 0) AND (dbo.SOP30200.DOCID = 'inv')
>ORDER BY dbo.SOP30200.SLPRSNID, dbo.SOP30200.CUSTNMBR
>UNION
>SELECT dbo.SOP30200.SLPRSNID, - (1 * dbo.SOP30200.DOCAMNT) AS expReturn
s
>FROM dbo.SOP30200 LEFT OUTER JOIN
> dbo.RM00101 ON dbo.SOP30200.CUSTNMBR =
>dbo.RM00101.CUSTNMBR LEFT OUTER JOIN
> dbo.viewSalesperson ON dbo.RM00101.SLPRSNID =
>dbo.viewSalesperson.SLPRSNID
>WHERE (dbo.SOP30200.DOCDATE >= CONVERT(DATETIME, '2006-02-15 00:00:00',
>102)) AND (dbo.SOP30200.DOCDATE <= CONVERT(DATETIME,
> '2006-03-01 00:00:00', 102)) AND
>(dbo.SOP30200.VOIDSTTS = 0) AND (dbo.SOP30200.SOPTYPE = 4) AND
>(dbo.SOP30200.DOCID = 'returns')
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200603/1|||Any suggestions on what I need to do to fix it?
"psychodad71 via webservertalk.com" <u2248@.uwe> wrote in message
news:5cf4869c57190@.uwe...
> order by of the first part of the union should be the problem.
> Colin wrote:
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...amming/200603/1|||Syntax is:
SELECT ... FROM ...
UNION (ALL)
SELECT ... FROM ...
ORDER BY...
(I also wonder why a TOP 100 PERCENT. That should return everything and
requires an ORDER BY to work. Get rid of the TOP 100 PERCENT> )
RLF
"Colin" <legendsfan@.nospam.nospam> wrote in message
news:etPkz6sQGHA.5924@.TK2MSFTNGP09.phx.gbl...
> Any suggestions on what I need to do to fix it?
> "psychodad71 via webservertalk.com" <u2248@.uwe> wrote in message
> news:5cf4869c57190@.uwe...
>|||Thanks for the help and feedback. I've got it working now. Is there a
reason why Visual Studio or any other design interface doesn't support
Design mode for UNION of two queries?
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:uWwHb5uQGHA.2816@.TK2MSFTNGP15.phx.gbl...
> Syntax is:
> SELECT ... FROM ...
> UNION (ALL)
> SELECT ... FROM ...
> ORDER BY...
> (I also wonder why a TOP 100 PERCENT. That should return everything and
> requires an ORDER BY to work. Get rid of the TOP 100 PERCENT> )
> RLF
> "Colin" <legendsfan@.nospam.nospam> wrote in message
> news:etPkz6sQGHA.5924@.TK2MSFTNGP09.phx.gbl...
>|||A few notes that may help you (and others):
1. TOP 100 Percent ... ORDER BY was a workaround/hack/creative piece of SQL
to try to get the optimizer to sort values at a point in the query plan.
Unfortunately, it didn't really work in all cases, and it actually isn't
being honored at all in SQL 2005. So, please consider removing this from
your code in the future.
2. As you've seen from the other posts, ORDER BY should be applied to the
end of the complete statement to affect the presentation order of the
results returned to the client (and not each block of the UNION).
3. The column binding rules for Jet Red (Access's engine) never really
conformed to the ANSI standards. Given the installed base, it's not likely
to be changed. So, just be aware that the queries you may have in your
Access application are sometimes interpreted in slightly different ways.
Best of luck,
Conor Cunningham
SQL Server Query Optimization Development Lead
"Colin" <legendsfan@.nospam.nospam> wrote in message
news:etPkz6sQGHA.5924@.TK2MSFTNGP09.phx.gbl...
> Any suggestions on what I need to do to fix it?
> "psychodad71 via webservertalk.com" <u2248@.uwe> wrote in message
> news:5cf4869c57190@.uwe...
>
Problems continued - Cannot establish remote connection to Analysis Services
hello,
i am trying to connect to Analysis services server through another pc but i am unable to do so.
Using the following commands i manage to connect to analysis services server at my pc
Server.srv=new Server ();
srv.Connect('ip address or name');
but not to another pc. Are there any settings under sql server should i change ?
I assume that you are using Analysis Services 2005.
First, make sure that the Analysis Services allows remote connections:
On the machine running analysis services, please perform the following steps:
- All programs\Microsoft SQL Server 2005\Configuration Tools\Sql Server Surface Area Configuration
- Click on the Surface Area Configuration for Services and Connections
- Select Remote Connections under the MSSQLSERVER\Analysis Services node
- Make sure that Local and Remote connections is selected (to allow remote connections)
At this point, the client machine should be able to connect to the remote server. Before everything works, you will need to make sure that the client machine connection code is running under credentials that can access Analysis Services
|||Well i have already enable remote connections and chech credentials as well
This is the error i am getting :
{"A connection cannot be made. Ensure that the server is running."} System.Exception {Microsoft.AnalysisServices.ConnectionException}
{"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"} System.Exception {System.Net.Sockets.SocketException}
Any help ? thanks.
|||That is unusual. Does PING work for the remote computer? Also, could you please check any firewall settings on the remote computer? Analysis Services (msmdsrv.exe) needs permissions through the firewall|||PING works fine among the two ps's and analysis services is excepted under firewall .
I am still facing the same problem.
Can you please provide me the exact connection string from a pc1 with ip 10.181.11.1 to a pc2 with ip 10.181.11.2 (asp form in pc1 to analysis server in pc2)?
Maybe i use a wrong connection string
This is the error i am getting :
Unable to read data from the transport connection : an existing connection was forcibly closed by the remote host
Any help?
Thanks
|||Are you using OLE DB or Adomd.Net?
The Connection String should look like "Data Source=10.181.11.2; Initial Catalog=<Your Database>"
One possible reason for the error is that your current user does not have permissions on the server. Are the computers in the same domain? If not, is Everyone allowed to access a database on the server?
|||I am using ADOMD connection,,if you have an example connection string it would be helpful to check with the one i use
(i have tried different ways of setting the connection string but still cannot connect ).
As far as user credentials are concerned i have also tried to set them in different ways.
I am not quite sure which user (WinXP user, Database Engine User , IIS user, Analysis Services user) must have access to which place,, i am a bit confused about this.
I appreciate your help. Thank you
|||To begin, let's make sure the physical connection works correctly. On the Analysis Services machine, create a new Analysis Services role which has permissions on your target database, and make sure that Everyone is a member of that role.
Then, try to connect from your client machine, using a connection string like
"Data Source=<IP of the remote machine>; Initial catalog=<name of the DB which is accessible to Everyone>"
If this works, the physical connection is OK and we'll focus on credentials.
Are your machines part of the same Windows NT domain? Tell me a few things about your application, I understand it is a web application, is it correct? Is it impersonating the remote user or running uner a set of specified credentials, or running under the default credentials (machine\ASPNET user)?
And, if you don't mind, could you please reply to this thread rather than creating a new post? It is easier to keep track of the issues
|||We did what you suggested but we still get the same error.
Do we need to give the permissions and to the actual database (database engine) except to the one in analysis services ?
Our machines are part of the same workgroup connected via a router.
It is a web application and it is runnig under the default credentials.
But we tried with a windows application to check if we can connect to the analysis services and we still get the error
We can access a remote database engine througn sql server management studio but not remote analysis services server.
Is there a way to access a remote analysis services through sql server management studio?
Thanks
|||This reply involves another error (not the one mentioned above). It seems to have a problem in creating the DIMENSION through source code and the problem seems to be on 'Process' command. We removed the Process command from the code and tried to process it through anaysis services management studio and still got error 'process failed' . This is a critical issue ,,i cannot continue to create cubes, etc.
As far as my application is concerned ,,it is a web application ,,the user will choose through an asp form measures and dimensions and then dimensions,cubes,structures will be created dynamically. So the problem is at initial state since i cannot create the dimenions.
Pls help.
This is the source code i use for dimension creation :
static void CreateDateDimension(Database db)
{
// Create the Date dimension
Dimension dim = db.Dimensions.Add("Invitquest");
dim.Type = DimensionType.Time;
dim.UnknownMember = UnknownMemberBehavior.Hidden;
dim.AttributeAllMemberName = "All Periods";
dim.Source = new DataSourceViewBinding(datasourceName);
dim.StorageMode = DimensionStorageMode.Molap;
#region Create attributes
DimensionAttribute attr;
attr = dim.Attributes.Add("Invitquest");
attr.Usage = AttributeUsage.Key;
attr.Type = AttributeType.Date;
attr.OrderBy = OrderBy.Key;
attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "invno"));
// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "tableid");
attr = dim.Attributes.Add("YPopto");
attr.Type = AttributeType.Regular;
attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "Ypopto"));
// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "Ypopto");
attr = dim.Attributes.Add("cancer");
attr.Type = AttributeType.Regular;
attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "CANCER"));
// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "CANCER");
attr = dim.Attributes.Add("AM BIO");
attr.Type = AttributeType.Regular;
attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "AMBIO"));
// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "AMBIO");
#endregion
dim.Update();
}
Thanks.
|||I merged all these threads.|||> Our machines are part of the same workgroup connected via a router.
This seems to be the issue. Analysis Services uses exclusively Windows Integrated security. User accounts are not shared across machines in a workgroup, only in a domain (or related domains). This might explain both the management studio failure as well as the custom application failure.
Can you try allowing Everyone access to the Analysis Services database? Eventually , the permissions for the Everyone role can be restricted to what is needed (most likely, Read Definition and predictions), but you can start with Everyone as administrator -- not a great security suggestion, but it allows you to easily figure out if this is the source of the problem.
sqlWednesday, March 21, 2012
Problems Connecting to MS SQL Server
After a new installation of MS Enterprise SQL Server, i am unable to connect
to the database from a website, and i dont know if MS SQL is working at all.
All the startup services and SQL services are started.Here is the website
that im trying to access my SQL server:
http://www.techparts.org/scripts/install.php
The error message is: Warning: mysql_connect(): Can't connect to MySQL
server on '10.10.8.6' (10061)
Here are the logistics:
The database name is “master” and I just reset the password for “db_we
bsite”
to “database”
Username: db_website
Password: database
Database: master
Host: 10.10.8.6 (MAIN)
Website: http://www.techparts.org/scripts/install.php
Forwarded Ports: 1433 and 3306 to 10.10.8.6
Firewall: No firewall on server or router
Software: MS SQL enterprise server, PHP, and SBS 2003
Permissions: db_website has full permissions to the master database
Authentication: db_website has full permissions to root and subfolders for
the website.
Is there something that im missing on the intial setup of SQL, and why cant
i login?You are trying to connect to MySQL. I'm not sure what
exactly you installed but it looks like you are confusing
Microsoft SQL Server and MySQL. They are two different
products.
For mysql questions, try posting to:
comp.databases.mysql
-Sue
On Tue, 25 Apr 2006 07:49:01 -0700, Tech Parts
<TechParts@.discussions.microsoft.com> wrote:
>After a new installation of MS Enterprise SQL Server, i am unable to connec
t
>to the database from a website, and i dont know if MS SQL is working at all
.
>All the startup services and SQL services are started.Here is the website
>that im trying to access my SQL server:
>http://www.techparts.org/scripts/install.php
>The error message is: Warning: mysql_connect(): Can't connect to MySQL
>server on '10.10.8.6' (10061)
>Here are the logistics:
>The database name is master and I just reset the password for db_website
>to database
>Username: db_website
>Password: database
>Database: master
>Host: 10.10.8.6 (MAIN)
>Website: http://www.techparts.org/scripts/install.php
>Forwarded Ports: 1433 and 3306 to 10.10.8.6
>Firewall: No firewall on server or router
>Software: MS SQL enterprise server, PHP, and SBS 2003
>Permissions: db_website has full permissions to the master database
>Authentication: db_website has full permissions to root and subfolders for
>the website.
>Is there something that im missing on the intial setup of SQL, and why cant
>i login?|||I assume what you're doing is trying to connect to SQL Server from PHP?
Chances are the connection string will be different for SQL Server than it
is for mysql so you may want to look at the connection string that is
actually used for the connection to see if it follows the SQL Server
conventions. ODBC queries are pretty standard but the connections string
aren't always. There may be information on the php site on how to do this -
or maybe someone here has done it successfully.
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
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:6als42do2hrecr933a16k2f22mo2iuo91b@.
4ax.com...
> You are trying to connect to MySQL. I'm not sure what
> exactly you installed but it looks like you are confusing
> Microsoft SQL Server and MySQL. They are two different
> products.
> For mysql questions, try posting to:
> comp.databases.mysql
> -Sue
> On Tue, 25 Apr 2006 07:49:01 -0700, Tech Parts
> <TechParts@.discussions.microsoft.com> wrote:
>
>|||Hi,
After this is over, you may want to change the password to the database and
never give it out again in a public newsgroup.
Nathan H. Omukwenyi
"Tech Parts" <TechParts@.discussions.microsoft.com> wrote in message
news:73123C3F-FD8F-463D-9E0C-9B54A1F395F0@.microsoft.com...
> After a new installation of MS Enterprise SQL Server, i am unable to
> connect
> to the database from a website, and i dont know if MS SQL is working at
> all.
> All the startup services and SQL services are started.Here is the website
> that im trying to access my SQL server:
> http://www.techparts.org/scripts/install.php
> The error message is: Warning: mysql_connect(): Can't connect to MySQL
> server on '10.10.8.6' (10061)
> Here are the logistics:
> The database name is "master" and I just reset the password for
> "db_website"
> to "database"
> Username: db_website
> Password: database
> Database: master
> Host: 10.10.8.6 (MAIN)
> Website: http://www.techparts.org/scripts/install.php
> Forwarded Ports: 1433 and 3306 to 10.10.8.6
> Firewall: No firewall on server or router
> Software: MS SQL enterprise server, PHP, and SBS 2003
> Permissions: db_website has full permissions to the master database
> Authentication: db_website has full permissions to root and subfolders for
> the website.
> Is there something that im missing on the intial setup of SQL, and why
> cant
> i login?
>
to the database from a website, and i dont know if MS SQL is working at all.
All the startup services and SQL services are started.Here is the website
that im trying to access my SQL server:
http://www.techparts.org/scripts/install.php
The error message is: Warning: mysql_connect(): Can't connect to MySQL
server on '10.10.8.6' (10061)
Here are the logistics:
The database name is “master” and I just reset the password for “db_we
bsite”
to “database”
Username: db_website
Password: database
Database: master
Host: 10.10.8.6 (MAIN)
Website: http://www.techparts.org/scripts/install.php
Forwarded Ports: 1433 and 3306 to 10.10.8.6
Firewall: No firewall on server or router
Software: MS SQL enterprise server, PHP, and SBS 2003
Permissions: db_website has full permissions to the master database
Authentication: db_website has full permissions to root and subfolders for
the website.
Is there something that im missing on the intial setup of SQL, and why cant
i login?You are trying to connect to MySQL. I'm not sure what
exactly you installed but it looks like you are confusing
Microsoft SQL Server and MySQL. They are two different
products.
For mysql questions, try posting to:
comp.databases.mysql
-Sue
On Tue, 25 Apr 2006 07:49:01 -0700, Tech Parts
<TechParts@.discussions.microsoft.com> wrote:
>After a new installation of MS Enterprise SQL Server, i am unable to connec
t
>to the database from a website, and i dont know if MS SQL is working at all
.
>All the startup services and SQL services are started.Here is the website
>that im trying to access my SQL server:
>http://www.techparts.org/scripts/install.php
>The error message is: Warning: mysql_connect(): Can't connect to MySQL
>server on '10.10.8.6' (10061)
>Here are the logistics:
>The database name is master and I just reset the password for db_website
>to database
>Username: db_website
>Password: database
>Database: master
>Host: 10.10.8.6 (MAIN)
>Website: http://www.techparts.org/scripts/install.php
>Forwarded Ports: 1433 and 3306 to 10.10.8.6
>Firewall: No firewall on server or router
>Software: MS SQL enterprise server, PHP, and SBS 2003
>Permissions: db_website has full permissions to the master database
>Authentication: db_website has full permissions to root and subfolders for
>the website.
>Is there something that im missing on the intial setup of SQL, and why cant
>i login?|||I assume what you're doing is trying to connect to SQL Server from PHP?
Chances are the connection string will be different for SQL Server than it
is for mysql so you may want to look at the connection string that is
actually used for the connection to see if it follows the SQL Server
conventions. ODBC queries are pretty standard but the connections string
aren't always. There may be information on the php site on how to do this -
or maybe someone here has done it successfully.
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
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:6als42do2hrecr933a16k2f22mo2iuo91b@.
4ax.com...
> You are trying to connect to MySQL. I'm not sure what
> exactly you installed but it looks like you are confusing
> Microsoft SQL Server and MySQL. They are two different
> products.
> For mysql questions, try posting to:
> comp.databases.mysql
> -Sue
> On Tue, 25 Apr 2006 07:49:01 -0700, Tech Parts
> <TechParts@.discussions.microsoft.com> wrote:
>
>|||Hi,
After this is over, you may want to change the password to the database and
never give it out again in a public newsgroup.
Nathan H. Omukwenyi
"Tech Parts" <TechParts@.discussions.microsoft.com> wrote in message
news:73123C3F-FD8F-463D-9E0C-9B54A1F395F0@.microsoft.com...
> After a new installation of MS Enterprise SQL Server, i am unable to
> connect
> to the database from a website, and i dont know if MS SQL is working at
> all.
> All the startup services and SQL services are started.Here is the website
> that im trying to access my SQL server:
> http://www.techparts.org/scripts/install.php
> The error message is: Warning: mysql_connect(): Can't connect to MySQL
> server on '10.10.8.6' (10061)
> Here are the logistics:
> The database name is "master" and I just reset the password for
> "db_website"
> to "database"
> Username: db_website
> Password: database
> Database: master
> Host: 10.10.8.6 (MAIN)
> Website: http://www.techparts.org/scripts/install.php
> Forwarded Ports: 1433 and 3306 to 10.10.8.6
> Firewall: No firewall on server or router
> Software: MS SQL enterprise server, PHP, and SBS 2003
> Permissions: db_website has full permissions to the master database
> Authentication: db_website has full permissions to root and subfolders for
> the website.
> Is there something that im missing on the intial setup of SQL, and why
> cant
> i login?
>
problems connecting to DB.
Hi,
thats what i get when running the app:
Server Error in '/Jobs5' Application.
Unable to open the physical file "C:\MPDB\ManPower.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
An attempt to attach an auto-named database for file C:\MPDB\ManPower.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Nothing seems to be using that file. So what is the problem?
Thanks.
The problem is that the DB is being used by the default web server of VS2005 whule i am trying to access using IIS.
the qu. is how do i make my application use IIS insted?
Thanks.
Tuesday, March 20, 2012
Problems after reinstall SQL 2000
I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
connect to server.
It′s installed on Windows 2000 Server SP4.
Thanks a lot.
What errors? Check your SQL Server error logs and the Windows Event viewer
(sys and app logs)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"jomagogre" <jomagogre@.discussions.microsoft.com> wrote in message
news:4FBDB47F-441E-4D9A-A736-1E4ADD64B445@.microsoft.com...
>I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> Its installed on Windows 2000 Server SP4.
> Thanks a lot.
|||Please try "SQLSERVERAGENT service" start with "Local System Account"
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It′s installed on Windows 2000 Server SP4.
> Thanks a lot.
|||I can see the following error in event viewer, trying to connect to sever
throught Enterprise Manager:
ID: 17055
Description:
17310:
process_login: el proceso 2276 gerenero una execption grave C0000005
EXCEPTIO_ACCESS_VIOLATION. Sql Server termina este proceso
When try to start SQLSERVERAGENT it′s register a menssage in event viewer
with ID: 103 telling that is imposible to start the service because the
server could not be contacted.
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It′s installed on Windows 2000 Server SP4.
> Thanks a lot.
SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
connect to server.
It′s installed on Windows 2000 Server SP4.
Thanks a lot.
What errors? Check your SQL Server error logs and the Windows Event viewer
(sys and app logs)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"jomagogre" <jomagogre@.discussions.microsoft.com> wrote in message
news:4FBDB47F-441E-4D9A-A736-1E4ADD64B445@.microsoft.com...
>I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> Its installed on Windows 2000 Server SP4.
> Thanks a lot.
|||Please try "SQLSERVERAGENT service" start with "Local System Account"
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It′s installed on Windows 2000 Server SP4.
> Thanks a lot.
|||I can see the following error in event viewer, trying to connect to sever
throught Enterprise Manager:
ID: 17055
Description:
17310:
process_login: el proceso 2276 gerenero una execption grave C0000005
EXCEPTIO_ACCESS_VIOLATION. Sql Server termina este proceso
When try to start SQLSERVERAGENT it′s register a menssage in event viewer
with ID: 103 telling that is imposible to start the service because the
server could not be contacted.
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It′s installed on Windows 2000 Server SP4.
> Thanks a lot.
Problems after reinstall SQL 2000
I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
connect to server.
It′s installed on Windows 2000 Server SP4.
Thanks a lot.What errors? Check your SQL Server error logs and the Windows Event viewer
(sys and app logs)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"jomagogre" <jomagogre@.discussions.microsoft.com> wrote in message
news:4FBDB47F-441E-4D9A-A736-1E4ADD64B445@.microsoft.com...
>I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> Its installed on Windows 2000 Server SP4.
> Thanks a lot.|||Please try "SQLSERVERAGENT service" start with "Local System Account"
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It′s installed on Windows 2000 Server SP4.
> Thanks a lot.|||I can see the following error in event viewer, trying to connect to sever
throught Enterprise Manager:
ID: 17055
Description:
17310:
process_login: el proceso 2276 gerenero una execption grave C0000005
EXCEPTIO_ACCESS_VIOLATION. Sql Server termina este proceso
When try to start SQLSERVERAGENT it′s register a menssage in event viewer
with ID: 103 telling that is imposible to start the service because the
server could not be contacted.
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It′s installed on Windows 2000 Server SP4.
> Thanks a lot.
SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
connect to server.
It′s installed on Windows 2000 Server SP4.
Thanks a lot.What errors? Check your SQL Server error logs and the Windows Event viewer
(sys and app logs)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"jomagogre" <jomagogre@.discussions.microsoft.com> wrote in message
news:4FBDB47F-441E-4D9A-A736-1E4ADD64B445@.microsoft.com...
>I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> Its installed on Windows 2000 Server SP4.
> Thanks a lot.|||Please try "SQLSERVERAGENT service" start with "Local System Account"
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It′s installed on Windows 2000 Server SP4.
> Thanks a lot.|||I can see the following error in event viewer, trying to connect to sever
throught Enterprise Manager:
ID: 17055
Description:
17310:
process_login: el proceso 2276 gerenero una execption grave C0000005
EXCEPTIO_ACCESS_VIOLATION. Sql Server termina este proceso
When try to start SQLSERVERAGENT it′s register a menssage in event viewer
with ID: 103 telling that is imposible to start the service because the
server could not be contacted.
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It′s installed on Windows 2000 Server SP4.
> Thanks a lot.
Problems after reinstall SQL 2000
I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
connect to server.
It´s installed on Windows 2000 Server SP4.
Thanks a lot.What errors? Check your SQL Server error logs and the Windows Event viewer
(sys and app logs)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"jomagogre" <jomagogre@.discussions.microsoft.com> wrote in message
news:4FBDB47F-441E-4D9A-A736-1E4ADD64B445@.microsoft.com...
>I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It´s installed on Windows 2000 Server SP4.
> Thanks a lot.|||Please try "SQLSERVERAGENT service" start with "Local System Account"
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It´s installed on Windows 2000 Server SP4.
> Thanks a lot.|||I can see the following error in event viewer, trying to connect to sever
throught Enterprise Manager:
ID: 17055
Description:
17310:
process_login: el proceso 2276 gerenero una execption grave C0000005
EXCEPTIO_ACCESS_VIOLATION. Sql Server termina este proceso
When try to start SQLSERVERAGENT it´s register a menssage in event viewer
with ID: 103 telling that is imposible to start the service because the
server could not be contacted.
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It´s installed on Windows 2000 Server SP4.
> Thanks a lot.
SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
connect to server.
It´s installed on Windows 2000 Server SP4.
Thanks a lot.What errors? Check your SQL Server error logs and the Windows Event viewer
(sys and app logs)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"jomagogre" <jomagogre@.discussions.microsoft.com> wrote in message
news:4FBDB47F-441E-4D9A-A736-1E4ADD64B445@.microsoft.com...
>I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It´s installed on Windows 2000 Server SP4.
> Thanks a lot.|||Please try "SQLSERVERAGENT service" start with "Local System Account"
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It´s installed on Windows 2000 Server SP4.
> Thanks a lot.|||I can see the following error in event viewer, trying to connect to sever
throught Enterprise Manager:
ID: 17055
Description:
17310:
process_login: el proceso 2276 gerenero una execption grave C0000005
EXCEPTIO_ACCESS_VIOLATION. Sql Server termina este proceso
When try to start SQLSERVERAGENT it´s register a menssage in event viewer
with ID: 103 telling that is imposible to start the service because the
server could not be contacted.
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It´s installed on Windows 2000 Server SP4.
> Thanks a lot.
Problems acessing the database after creating a website on localhost
I cannot access the data source when I create a website in express - when I try to connect to the database I get an error telling that I am unable to connect to the data source - I tried doing it through the Visual Studio and through the Web Configaration.
Can some please help - I need to conncet!!!
What the connction string and the exact error message ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
"Failed to generate a user instance of SQL Server due to failure in starting the process for the user instance. The connection will be closed"
This is the error messgae that I get when I try to connect to the data source.
Can you help?
|||Do you have SQL Server Express installed ?Jens K. Suessmeyer
http://www.sqlserver2005.de
|||
Reese C. M. Harris wrote:
"Failed to generate a user instance of SQL Server due to failure in starting the process for the user instance. The connection will be closed"
This is the error messgae that I get when I try to connect to the data source.
Can you help?
This is a known issue and the solution is the one posted by user Reen in the long thread below. Hope this helps.
http://forums.microsoft.com/msdn/showpost.aspx?postid=293667&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=0Friday, March 9, 2012
problem(Unable to add data connection)
Im having trouble creating a new connection through Visual Studio Web Developer. When I try to add a new connection all it gives me is an error-
Unable to add data connection
The DataConnectionDialog could not be intialized
When I test my page it seems alright going to the localhost but when I try to add a connection it wont let me.
What could be the cause?
And how can I fix this problem?
I want to connect to the sql server on my computer.. I cant because of the error above
Hi Leo,
I'm going to claim "not my technology" and send you to another forum. The place that is specifically about SQL Express in VWD is at http://forums.asp.net/54/ShowForum.aspx and I think you'll get a better answer there.
Regards,
Mike Wachal
SQL Express team
-
Mark the best posts as Answers!
Subscribe to:
Posts (Atom)