Showing posts with label msde. Show all posts
Showing posts with label msde. Show all posts

Thursday, March 29, 2012

Can't connect as SA through ODBC manager...why?

Hi All,
I can connect to my MSDE server by logging in as SA from the command line
but not through the ODBC manager utility in windows. I need to setup system
DSNs for a few applications but can't because they require I use SQL
authentication. When I reach that step in the ODBC manager I type in SA and
the password and hit next I get a 18456 "login failed for sa" error. My
server is in mixed mode (I checked the registry), the domain admins group has
login privilages to MSDE, I have no firewall active on any NICs, and none of
my passwords contain a semicolon. I have no clue what I'm missing here. Can
some one point me in the right direction or link me to a good article on how
to setup system dsns through the command line?
Thanks,
Prikly Pete Peterson
MSDE can only be used as the source of the data. It's not licensed to host
Reporting Services (as we discuss in our Reporting Services
book --www.sqlreportingservices.net). Chapter 2 (freely downloadable from
the site) explains why.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"ComfortablySAD" <ComfortablySAD@.discussions.microsoft.com> wrote in message
news:32E686BF-63A6-4DFF-9A7D-A00E8B6CAE09@.microsoft.com...
> Hi All,
> I can connect to my MSDE server by logging in as SA from the command line
> but not through the ODBC manager utility in windows. I need to setup
> system
> DSNs for a few applications but can't because they require I use SQL
> authentication. When I reach that step in the ODBC manager I type in SA
> and
> the password and hit next I get a 18456 "login failed for sa" error. My
> server is in mixed mode (I checked the registry), the domain admins group
> has
> login privilages to MSDE, I have no firewall active on any NICs, and none
> of
> my passwords contain a semicolon. I have no clue what I'm missing here.
> Can
> some one point me in the right direction or link me to a good article on
> how
> to setup system dsns through the command line?
> Thanks,
> Prikly Pete Peterson
sql

Can't connect after Windows XP SP2

Has i reviewed here after Windows XP SP2, MSDE has some problems conecctiong
over a network.
I installed SP3a for MSDE 2000 but the problem persists.
I put a permission to sqlserver.exe but my access to it over a network (and
internet) is blocked.
How can i solve this problem?
thanks,
Goncalo Boleo
hi,
"john raub" <john_raub@.ascendrms.com> ha scritto nel messaggio
news:20c601c4bdd8$f28b0840$a601280a@.phx.gbl
> problem with a customer that installed a 3rd party
> firewall software. He has since uninstalled, but we still
> can't connect to the machine containing the MSDE server.
please have a look at
http://support.microsoft.com/default.aspx?scid=kb;[LN];841251
http://support.microsoft.com/default.aspx?kbid=841249
http://support.microsoft.com/default.aspx?scid=kb;[LN];884012
to see if they can help
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

can't connect

hey all,
i'm trying, unsuccessfully, to connect to my msde(sp4) which is on another
pc (has xp sp2) wirelessly thru a virtual pc which has Enterprise Manager on
it.
My results have been a moving target. One day i can connect via my virtual
pc with enterprise manager and the next day i can connect via my host pc with
a plain UDL link but never both.
i don't understand the inconsistency in connecting to the pc that has msde
on it. i've successfully mapped a drive to it. the msde machine's windows
firewall is on accepting file and print sharing (port 445 enabled). i have a
4-port wireless router and as i mentioned before i'm trying to connect
wirelessly.
am i missing something here?
thanks,
rodchar
how do i verify my network is working properly?
"Andrea Montanari" wrote:

> hi Rodchar,
> rodchar wrote:
> you do not need to have file system shares to connect to.. you only have to
> worry about "general" network connectivity across the involved machines and
> that the target server accepts remote connections (as it already should, as
> you get some sort of connectivity)...
> verify your network is poroperly working..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>

Sunday, March 25, 2012

Cant attach a database using MSDE deployment toolkit

I am using the MSDE deployment toolkit along with the
sample programs provided by Mario S. Almost everything is
fine when I want to create a database, add tables, and
etc. but I am unable to attach a database.
On one instance called "george" i have created a database
called "lawncare" and moved it to the C: drive. I am using
the same embedded resource file "DBInstall.sql" that is
used in the examples (and which works for creating tables,
etc) but I receive the following error message:
"An exception occured in the ONAfterInstall event handler
of DBInstaller.CustomInstaller.
>Line 2: Incorrect systax near 'go'
Line 4: Incorrect syntax near 'go'"
The script I am using in the resource file is:
set nocount off
go
exec sp_attach_single_file_db @.dbname = 'lawncare',
@.physname = 'c:\lawncare_Data.mdf'
go
If, in the same resource file I were to use this script:
CREATE TABLE [dbo].[City] (
[CityId] [int] IDENTITY (0, 1) NOT NULL ,
[Description] [varchar] (50) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
The table would be created just fine...(the routine
substitutes ";" for "go" when reading the text to execute.)
Any help would be appreciated.
Thanks
NJ
NJ,
Your sql is working fine, I tried it and it worked. But make sure that this database that you are trying to attach is actually detached from somewhere before. The sp_attach_single_file_db works with databases which are detached from somewhere. Also mak
e sure that your log file is at c:\ drive too .
let me know if it doesn't work.
dev

Thursday, March 22, 2012

Can't Access SQL Server

Help! I've been hacked! I'm running SQL 7 Desktop (MSDE) and started getting
these messages at startup that servudaemon.exe was going to be shut down.
Then, at one point, I keep getting prompted by Norton Firewall that
serve-u.exe is trying to access the Internet. It suggested I deny it, which
I did; but I kept getting prompted every minute or so, so finally I told
Norton Firewall to always deny it.
Then, some minutes later, I close an Access 2000 mdb file I had opened which
uses SQL Server as a back end (through linked tables), and I was told that
connection to SQL Server had been lost. I tried reconnecting, but couldn't.
So I went into Enterprise Manager, and was told: "A connection could not be
established to D23 - Login failed for user 'sa'.."
So I went into Registration Properties, and saw that there was a password
there. I previously didn't have a password for 'sa' (which I know is stupid,
and now see the result of it). But there's a password now, and I can't
change it. So whatever hacked into my system set my 'sa' password.
Just to be sure that my settings in Norton Firewall weren't affecting
anything, I disconnected from the Internet and then disabled Norton Personal
Firewall. The results were the same.
So is there any way to restore my system?
Thanks for any assistance.
Neilserve-u.exe is possible ServeU, which is a popular FTP program. It seems
that you may have been hacked, and someone has configured an FTP site on
your machine (eg for serving mp3s, or warez or similar)
If you are a local administrator on the SQL Server machine, you should still
be able to login to SQL Server (using your Windows admin account, not the
"sa" account). You could reset the "sa" password then.
That said, you need to work out how these people got into your machine in
the first place. Additionally, since you don't know what other "back doors"
they have installed which might let them back in again, I'd say your best
bet is to backup your data, and then setup the machine from scratch.
Cheers
Ken
"Neil Ginsberg" <nrg@.nrgconsult.com> wrote in message
news:vfS4c.37319$aT1.26124@.newsread1.news.pas.earthlink.net...
: Help! I've been hacked! I'm running SQL 7 Desktop (MSDE) and started
getting
: these messages at startup that servudaemon.exe was going to be shut down.
: Then, at one point, I keep getting prompted by Norton Firewall that
: serve-u.exe is trying to access the Internet. It suggested I deny it,
which
: I did; but I kept getting prompted every minute or so, so finally I told
: Norton Firewall to always deny it.
:
: Then, some minutes later, I close an Access 2000 mdb file I had opened
which
: uses SQL Server as a back end (through linked tables), and I was told that
: connection to SQL Server had been lost. I tried reconnecting, but
couldn't.
: So I went into Enterprise Manager, and was told: "A connection could not
be
: established to D23 - Login failed for user 'sa'.."
:
: So I went into Registration Properties, and saw that there was a password
: there. I previously didn't have a password for 'sa' (which I know is
stupid,
: and now see the result of it). But there's a password now, and I can't
: change it. So whatever hacked into my system set my 'sa' password.
:
: Just to be sure that my settings in Norton Firewall weren't affecting
: anything, I disconnected from the Internet and then disabled Norton
Personal
: Firewall. The results were the same.
:
: So is there any way to restore my system?
:
: Thanks for any assistance.
:
: Neil
:
:|||sp3A is designed to stop access to the IO Port that exposes MSDE (and SQL
Server) to the web.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Ken Schaefer" <kenREMOVE@.THISadOpenStatic.com> wrote in message
news:%23Wam0XbCEHA.3132@.TK2MSFTNGP11.phx.gbl...
> serve-u.exe is possible ServeU, which is a popular FTP program. It seems
> that you may have been hacked, and someone has configured an FTP site on
> your machine (eg for serving mp3s, or warez or similar)
> If you are a local administrator on the SQL Server machine, you should
still
> be able to login to SQL Server (using your Windows admin account, not the
> "sa" account). You could reset the "sa" password then.
> That said, you need to work out how these people got into your machine in
> the first place. Additionally, since you don't know what other "back
doors"
> they have installed which might let them back in again, I'd say your best
> bet is to backup your data, and then setup the machine from scratch.
> Cheers
> Ken
> "Neil Ginsberg" <nrg@.nrgconsult.com> wrote in message
> news:vfS4c.37319$aT1.26124@.newsread1.news.pas.earthlink.net...
> : Help! I've been hacked! I'm running SQL 7 Desktop (MSDE) and started
> getting
> : these messages at startup that servudaemon.exe was going to be shut
down.
> : Then, at one point, I keep getting prompted by Norton Firewall that
> : serve-u.exe is trying to access the Internet. It suggested I deny it,
> which
> : I did; but I kept getting prompted every minute or so, so finally I told
> : Norton Firewall to always deny it.
> :
> : Then, some minutes later, I close an Access 2000 mdb file I had opened
> which
> : uses SQL Server as a back end (through linked tables), and I was told
that
> : connection to SQL Server had been lost. I tried reconnecting, but
> couldn't.
> : So I went into Enterprise Manager, and was told: "A connection could not
> be
> : established to D23 - Login failed for user 'sa'.."
> :
> : So I went into Registration Properties, and saw that there was a
password
> : there. I previously didn't have a password for 'sa' (which I know is
> stupid,
> : and now see the result of it). But there's a password now, and I can't
> : change it. So whatever hacked into my system set my 'sa' password.
> :
> : Just to be sure that my settings in Norton Firewall weren't affecting
> : anything, I disconnected from the Internet and then disabled Norton
> Personal
> : Firewall. The results were the same.
> :
> : So is there any way to restore my system?
> :
> : Thanks for any assistance.
> :
> : Neil
> :
> :
>|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.msde:13508 microsoft.p
ublic.sqlserver.security:19785 microsoft.public.sqlserver.connect:41876
I'm running SQL 7. Do you know if there's a similar sp for that?
Neil
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:%23RoIB3fCEHA.1544@.TK2MSFTNGP09.phx.gbl...
> sp3A is designed to stop access to the IO Port that exposes MSDE (and SQL
> Server) to the web.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Ken Schaefer" <kenREMOVE@.THISadOpenStatic.com> wrote in message
> news:%23Wam0XbCEHA.3132@.TK2MSFTNGP11.phx.gbl...
> still
the
in
> doors"
best
> down.
told
> that
not
> password
>

Tuesday, March 20, 2012

can't access server - lost sa password

We have what we think is msde running on a box. No one knows the sa password.
I am in the domain admin group on Windows and the Windows admin group but
when I right click on BUILTIN\administrator, I don't get the "properties"
menu selection. I also can't create a new login.
A few weeks ago I was able to create a new login and a new database. I'm not
sure what happened. My windows login is not there anymore but I would have
thought I could use the BUILTIN\administrator login to admin the server.
Any ideas on how I can get control of the server?
Thanks,
Dan D.
Although I hate tools like these but try this tool if it works for you ...
http://www.nextgenss.com/sqlcrack.htm
Harman Sahni
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:E449D233-29E8-4ED0-AC95-2B4BF0FDC6D3@.microsoft.com...
> We have what we think is msde running on a box. No one knows the sa
password.
> I am in the domain admin group on Windows and the Windows admin group but
> when I right click on BUILTIN\administrator, I don't get the "properties"
> menu selection. I also can't create a new login.
> A few weeks ago I was able to create a new login and a new database. I'm
not
> sure what happened. My windows login is not there anymore but I would have
> thought I could use the BUILTIN\administrator login to admin the server.
> Any ideas on how I can get control of the server?
> Thanks,
> --
> Dan D.
|||Thanks but I figured out the sa password. I'll keep this for future reference.
"Harman Sahni" wrote:

> Although I hate tools like these but try this tool if it works for you ...
> http://www.nextgenss.com/sqlcrack.htm
> Harman Sahni
>
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:E449D233-29E8-4ED0-AC95-2B4BF0FDC6D3@.microsoft.com...
> password.
> not
>
>
|||Dan
Log in SQL Server with Windows Authentication and run EXEC sp_password NULL,
'NewPass', 'MyUser
'
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:2264F204-A7B6-422A-95AC-0517B560C27C@.microsoft.com...
> Thanks but I figured out the sa password. I'll keep this for future
reference.[vbcol=seagreen]
> "Harman Sahni" wrote:
...[vbcol=seagreen]
but[vbcol=seagreen]
"properties"[vbcol=seagreen]
I'm[vbcol=seagreen]
have[vbcol=seagreen]
server.[vbcol=seagreen]

Can't Access Named Instanced With Network Protocol Disabled

Hi there,
I have a little question here.
I've installed a named instance of MSDE SP4 called mydb, with network
protocols disabled.
Then I noticed that I can't connect to it using OSQL
I tried
'osl -S (local)\mydb -E'
'osl -S localhost\mydb -E'
and both of them can't connect to the database, however.
'osql -S mypcname\mydb -E'
works perfectly... I don't want to manually fill in the machine name for
each connection string can someone tell me why (local) doesn't seem to
connect to the local machine? Does it have anything to do with network
protocols disabled?
Thanks.
Hi
(local) and localhost rely on the network stack to resolve. If you network
is disabled, there is nothing there to resolve the name. localhost resolves
to 127.0.0.1 by TCP/IP.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Marauderz" <marauderz@.nospam.com> wrote in message
news:u1dlfrAqFHA.3720@.TK2MSFTNGP14.phx.gbl...
> Hi there,
> I have a little question here.
> I've installed a named instance of MSDE SP4 called mydb, with network
> protocols disabled.
> Then I noticed that I can't connect to it using OSQL
> I tried
> 'osl -S (local)\mydb -E'
> 'osl -S localhost\mydb -E'
> and both of them can't connect to the database, however.
> 'osql -S mypcname\mydb -E'
> works perfectly... I don't want to manually fill in the machine name for
> each connection string can someone tell me why (local) doesn't seem to
> connect to the local machine? Does it have anything to do with network
> protocols disabled?
> Thanks.
>

Can't access msde installation from network

I've installed a msde copy on a Win2000 pro computer, but when I try to
connect to it from another computer, it doesn't allow me to log on. Is it a
internal limit?
MSDE doesn't by default have network connectivity turned on. Enable using svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hawz" <ohawz@.hotmail.com> wrote in message news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> I've installed a msde copy on a Win2000 pro computer, but when I try to
> connect to it from another computer, it doesn't allow me to log on. Is it a
> internal limit?
>
|||I've enabled tcp/ip, named pipe and multi-protocal. But still can't get
connected. It says "General network error. Please check network document
ConnectionOpen (PreLoginHandshake()"
And I also can't use telnet to connect to 1433 port.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ObJ9CvyNEHA.2708@.TK2MSFTNGP11.phx.gbl...
> MSDE doesn't by default have network connectivity turned on. Enable using
svrnetcn.exe.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Hawz" <ohawz@.hotmail.com> wrote in message
news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
it a
>
|||Perhaps there's a firewall in between?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hawz" <ohawz@.hotmail.com> wrote in message news:%2324RZQ7NEHA.644@.tk2msftngp13.phx.gbl...
> I've enabled tcp/ip, named pipe and multi-protocal. But still can't get
> connected. It says "General network error. Please check network document
> ConnectionOpen (PreLoginHandshake()"
> And I also can't use telnet to connect to 1433 port.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ObJ9CvyNEHA.2708@.TK2MSFTNGP11.phx.gbl...
> svrnetcn.exe.
> news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> it a
>
|||This might help:
http://support.microsoft.com/default...b;en-us;826829
-oj
http://www.rac4sql.net
"Hawz" <ohawz@.hotmail.com> wrote in message
news:%2324RZQ7NEHA.644@.tk2msftngp13.phx.gbl...
> I've enabled tcp/ip, named pipe and multi-protocal. But still can't get
> connected. It says "General network error. Please check network document
> ConnectionOpen (PreLoginHandshake()"
> And I also can't use telnet to connect to 1433 port.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ObJ9CvyNEHA.2708@.TK2MSFTNGP11.phx.gbl...
> svrnetcn.exe.
> news:uoGN99uNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> it a
>

can't access MSDE database after setup

I can't log in with osql. My setup config file is as below.
[Options]
INSTANCENAME=NetSDK
SECURITYMODE=SQL
SAPWD=mypassword
It seems to install and run (green arrow in service bar after giving
it
myservername\NetSDK). Then I try this:
osql -U sa
Password: 'I give mypassword here
[Shared Memory]SQL Server does not exists or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What does this mean? Am I missing something basic? I would really like
to use MSDE, but it seems broken or I just don't have enough
information.
Please cc to jhestess@.yahoo.com. Thanks in advance.
John Estess
El Paso, Texas
This may be a problem with ports or other things. Try these:
"Potential causes of the "SQL Server Does Not Exist or Access Denied" error message"
http://support.microsoft.com/default...06&Product=sql
http://support.microsoft.com/?id=287932
http://support.microsoft.com/default.aspx?kbid=814130
Mark Ferguson
"John Estess" wrote:

> I can't log in with osql. My setup config file is as below.
> [Options]
> INSTANCENAME=NetSDK
> SECURITYMODE=SQL
> SAPWD=mypassword
> It seems to install and run (green arrow in service bar after giving
> it
> myservername\NetSDK). Then I try this:
> osql -U sa
> Password: 'I give mypassword here
> [Shared Memory]SQL Server does not exists or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What does this mean? Am I missing something basic? I would really like
> to use MSDE, but it seems broken or I just don't have enough
> information.
> Please cc to jhestess@.yahoo.com. Thanks in advance.
> John Estess
> El Paso, Texas
>
|||hi John,
"John Estess" <jhestess@.yahoo.com> ha scritto nel messaggio
news:136cf350.0406250942.1417a8a7@.posting.google.c om...
> I can't log in with osql. My setup config file is as below.
> [Options]
> INSTANCENAME=NetSDK
> SECURITYMODE=SQL
> SAPWD=mypassword
> It seems to install and run (green arrow in service bar after giving
> it
> myservername\NetSDK). Then I try this:
> osql -U sa
> Password: 'I give mypassword here
> [Shared Memory]SQL Server does not exists or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What does this mean? Am I missing something basic? I would really like
> to use MSDE, but it seems broken or I just don't have enough
> information.
> Please cc to jhestess@.yahoo.com. Thanks in advance.
> John Estess
> El Paso, Texas
try
c:\>osql -Smyservername\NetSDK -Usa -Pyour_pwd
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Thursday, March 8, 2012

Cannot Upgrade MSDE 2000 Sp3 to SP4

Hi!

Here's the scenario:

I have a MSDE 2000 installation running, already patched to SP3. Instancename is "STO". I've downloaded SQL2000.MSDE-KB884525-SP4-X86-ENU.exe and extracted the archive to C:\SQL2KSP4.

After starting setup from the command prompt with "setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=0 /L*V C:\MSDELog.log" i get a message box, telling me "The product is not installed". This happens even if I specify the exact instancename and supply the sa user and pwd!

Any ideas?`

Thanks in advance and regards

Clemens

In your command line, you need to specify the instance name and sa pass word. Would you try the following command line?

start /wait setup.exe /qb INSTANCENAME=sto SAPWD="<sa pass word>" SECURITYMODE=SQL

|||

Thx for your reply, but if you look at my post above, you'll see that i also tried that! ;-)

Quote:

"This happens even if I specify the exact instancename and supply the sa user and pwd!"

Rgds

Clemens

|||In your command line, you do not specify the instance name. It is required for an upgrading. Would you check and try?

cannot update table

I have an msde database connected to a microsoft project front end.
I am trying to update a table with values. When I use a stored procedure
everything works fine but when I try and edit the table directly I am warned
that the 'the recordset is not updatable'
Is this 'by design'? or are there permission issues?
I am logged into the database as a user almx who has database creation
rights.
I tried logging into the database as sa but I it makes no difference.
Are there any specific permissions I need to set to allow users to update
the table values directly or is this not possible in a MS Access Project?
June
Access won't allow you to update records unless there's a primary key
or unique index defined on the tables.
--Mary
On Wed, 16 Jun 2004 12:24:34 +0100, "June Macleod"
<junework@.hotmail.com> wrote:

>I have an msde database connected to a microsoft project front end.
>I am trying to update a table with values. When I use a stored procedure
>everything works fine but when I try and edit the table directly I am warned
>that the 'the recordset is not updatable'
>Is this 'by design'? or are there permission issues?
>I am logged into the database as a user almx who has database creation
>rights.
>I tried logging into the database as sa but I it makes no difference.
>Are there any specific permissions I need to set to allow users to update
>the table values directly or is this not possible in a MS Access Project?
>June
>

Wednesday, March 7, 2012

Cannot start Sql service

Hi guys,
I had 2 SQL Servers on my machine, one was the MSDE netSDK
and the other was MS SQL Server 2000.
I removed the latter as I was quite happy with MSDE but
as soon as I removed it the play icon in the SQL Manager
disappeared and I get a message saying
'Cannot find the file specified' as there is nothing in
the services drop down combo. How do I fix this. I still
have all my databases in the netSDK.
Thanks in advance
Regards
tribalIfI remember correctly removing the SQL Server instance removes all of the
GUI tools. You'll need to find a free GUI for the MSDE since the once that
came with SQL Server are gone.
"tribal" <tribal@.mail.com> wrote in message
news:04a601c368ab$0d62f030$a001280a@.phx.gbl...
> Hi guys,
> I had 2 SQL Servers on my machine, one was the MSDE netSDK
> and the other was MS SQL Server 2000.
> I removed the latter as I was quite happy with MSDE but
> as soon as I removed it the play icon in the SQL Manager
> disappeared and I get a message saying
> 'Cannot find the file specified' as there is nothing in
> the services drop down combo. How do I fix this. I still
> have all my databases in the netSDK.
> Thanks in advance
> Regards
> tribal

Saturday, February 25, 2012

Cannot specify 'dimension' for: Maintenance plan remove files older than

OS: Windows Server 2003 Standard Edition. MSDE 2000.

SQL Server Enterprise Manager Version 8.0.

The Maintenance Plan Wizard will not allow me to specify a value for the 'Remove Files...' I can enter a number but there is nothing in the drop down e.g. 3 'DAYS' perhaps?

Create then plan and then edit - yields the same result.

Any ideas on why there is no 'dimension' for Remove Files Older than ?

Appreciate any tips, ideas, etc.

Thank.s

Anybody have issues trying to specify a dimension for 'Remove Files...' either during Maintenance Wizard (create) or afterwards - edit properties?

The drop down - where you would expect a list of values like: day, week, month - is completely blank?

|||

I'm experiencing the exact same problem with my MSDE database. I cannot specify anything as to days, weeks, etc. It also will take other information, such as scheduling, directory, extension name, and actually create the jobs correctly, but then when you go back to the Maintenance Plan, you find the information has disappeared. If you try to modify any other aspect of the plan, you get an error, because this information is now missing. This is the only MSDE db I have, all the rest are standard or enterprise and work normally from the same Enterprise Manager.

I have not found any explanation or work-around for this problem.

Cannot specify 'dimension' for: Maintenance plan remove files older than

OS: Windows Server 2003 Standard Edition. MSDE 2000.

SQL Server Enterprise Manager Version 8.0.

The Maintenance Plan Wizard will not allow me to specify a value for the 'Remove Files...' I can enter a number but there is nothing in the drop down e.g. 3 'DAYS' perhaps?

Create then plan and then edit - yields the same result.

Any ideas on why there is no 'dimension' for Remove Files Older than ?

Appreciate any tips, ideas, etc.

Thank.s

Anybody have issues trying to specify a dimension for 'Remove Files...' either during Maintenance Wizard (create) or afterwards - edit properties?

The drop down - where you would expect a list of values like: day, week, month - is completely blank?

|||

I'm experiencing the exact same problem with my MSDE database. I cannot specify anything as to days, weeks, etc. It also will take other information, such as scheduling, directory, extension name, and actually create the jobs correctly, but then when you go back to the Maintenance Plan, you find the information has disappeared. If you try to modify any other aspect of the plan, you get an error, because this information is now missing. This is the only MSDE db I have, all the rest are standard or enterprise and work normally from the same Enterprise Manager.

I have not found any explanation or work-around for this problem.

Tuesday, February 14, 2012

Cannot see MSDE Sever on network

Hi everyone.
I have installed MSDE on Win 200 Pro. everything works fine when i try to connect on the local maschine, but when i try to get a connection from another computer, then
he cannot find the server, when i look with enterprise menager the same thing.
have any idea?
Hi,
Can you enable the TCPIP protocol using the utility svrnetcn.exe from SQL
server machine. Run the
svrnetcn.exe from command prompt and after enabling the protocol stop and
start the MSSQL server Service .
After starting the service try connecting remotely.
Thanks
Hari
MCDBA
"adriatik" <adriatik@.discussions.microsoft.com> wrote in message
news:05E3CEA8-D04D-4516-8668-D2C4D610E4A8@.microsoft.com...
> Hi everyone.
> I have installed MSDE on Win 200 Pro. everything works fine when i try to
connect on the local maschine, but when i try to get a connection from
another computer, then
> he cannot find the server, when i look with enterprise menager the same
thing.
> have any idea?
>
|||Hi Hari,
thank you for your reply.
it works fine.
many thanks,
adriatik
"Hari Prasad" wrote:

> Hi,
> Can you enable the TCPIP protocol using the utility svrnetcn.exe from SQL
> server machine. Run the
> svrnetcn.exe from command prompt and after enabling the protocol stop and
> start the MSSQL server Service .
> After starting the service try connecting remotely.
> Thanks
> Hari
> MCDBA
>
> "adriatik" <adriatik@.discussions.microsoft.com> wrote in message
> news:05E3CEA8-D04D-4516-8668-D2C4D610E4A8@.microsoft.com...
> connect on the local maschine, but when i try to get a connection from
> another computer, then
> thing.
>
>

Cannot see an instance with BrowseConnect or OSQL /L

This summary is not available. Please click here to view the post.

Cannot see an instance with BrowseConnect or OSQL /L

Hi,
I have 3 instances of SQL server currently on my machine. The default
instance is MSDE 2000, I also have an SQL Express 2005 instance
\MACHINE\SQLEXPRESS and I have an instance of SQL Server 2000 Workgroup
Edition, named \MACHINE\WORKGROUP. When I execute SqlBrowseConnect or
"ListAllAvailableInstances" from SQL-DMO methods, I can see the 2005
instance and the default instance (local), but not the workgroup instance.
When I execute OSQL /L, I get the same result. I cannot see the Workgroup
Instance. I can however connect to the workgroup instance via. management
studio and can register it with SQL Server Configuration Manager.
I can connect to it via. OSQL and execute statements however, if I specify
the instance name on the command line. Any ideas on why it isn't visible?
According to connection properties in Management Studio (Server
Properties -> Connections), "allow remote connections" is switched on.
Robin
Okay, I fixed this by using the registry for local enumeration. Still, it's
a bit suprising to me that the browser won't enumerate all local instances -
or at least that there isn't a solid mechanism for doing so apart from
accessing the registry.
"Robinson" <toomuchspamhaspassed@.myinboxtoomuchtoooften.com > wrote in
message news:ego20b$g7q$1$830fa17d@.news.demon.co.uk...
> Hi,
> I have 3 instances of SQL server currently on my machine. The default
> instance is MSDE 2000, I also have an SQL Express 2005 instance
> \MACHINE\SQLEXPRESS and I have an instance of SQL Server 2000 Workgroup
> Edition, named \MACHINE\WORKGROUP. When I execute SqlBrowseConnect or
> "ListAllAvailableInstances" from SQL-DMO methods, I can see the 2005
> instance and the default instance (local), but not the workgroup instance.
> When I execute OSQL /L, I get the same result. I cannot see the Workgroup
> Instance. I can however connect to the workgroup instance via.
> management studio and can register it with SQL Server Configuration
> Manager.
> I can connect to it via. OSQL and execute statements however, if I specify
> the instance name on the command line. Any ideas on why it isn't visible?
> According to connection properties in Management Studio (Server
> Properties -> Connections), "allow remote connections" is switched on.
>
> Robin
>