this is probably going to seem like a crazy thing to post because i'm not looking to get into IT/IS, i'm looking to shift somewhat out of it.
History:
BA & MS in Interpersonal Communication (so study of people & communication dynamics)
worked as HR Generalist for 2 years before going on to a...
OMG! i think i figured it out! it involved Named Pipes (which i have heard of but don't understand) & credentials. here's what my final statement in my .bat file looks like
sqlcmd -S "np:\\.\pipe\MSSQL$NamedInstance\sql\query" -Uuser -Ppassword -ic:\mybackup.sql
i got this from the other...
well and now after a little more research & comparison, i don't find a sqlcmd.exe anywhere on my server. i even looked for osql & isql just grabbing ideas & find nothing. so i'm not sure exactly what exe would kick off the .sql file.
well anyone that can help me with the last step, i'd greatly appreciate it. i was able to use the Script To in Express to script out a backup titled sql_bu.sql:
BACKUP DATABASE [DBName] TO DISK = N'D:\Backup\DBName.bak' WITH NOFORMAT, NOINIT, NAME = N'Full Database Backup', SKIP, NOREWIND...
thanks dj55. not sure if i'm on the exact same track as you, but i did try going onto another SQL server in this vendor supplied system (there are 3 & the other 2 run SQL 2008 Standard). so i thought, i'll just connect to my Express server via SQL Standard from one of the other 2 servers &...
i've searched the forums here & found a few question/answers that speak a little to my question, but not completely. i perform basic SQL administration on several 2005 & 2008 SQL servers but i encountered my first vendor-supplied SQL Server Express 2008 server today. i need to set up full...
yes, explained to her the pdf was going to be the bigger problem unless she had Acrobat. i have not heard back from her & most people only have Reader. i'll be surprised if she has more than Reader, but you never know! thanks again for the help!
thank you both. i will pass that on to her. i think it's a bit unreasonable too but it is her thesis & thesis committees are known for that sort of thing.
i have been asked to research the following for a co-worker. we will assume Word 2007 at this point:
My only question/problem that I have at this time is with formating my appendices. I have to include all the documents that I used as handouts at my event, in the appendices. Where I am...
wow! i think i figured it out. after getting into the CMC and finding the Concurrent vs Named User settings, i was not able to edit/change the setting for Guest. i went to the Licensing section and didnt' see my key entered on this page, so i Added it. this then showed me the "stats" for my...
i did at least find the URL for the CMC. but i have no idea what the login is or what to use for the different Authentication Types. i'll keep fishing!
Turkbear, if you're still out there.....even though the Services started, i'm getting the same error message reported in this posting:
http://www.tek-tips.com/viewthread.cfm?qid=1066456&page=10
i've forwarded the posting to my software vendor to have them look into this as i have no Crystal...
but i'm not having issues running the services now. it was just the CMS. it runs if i check the default port of 6400, but if i uncheck default and try to use 6401, it won't start. the secondary issue is that the CE10 is not displaying in the CMS Data Source field on the Config tab. my odbc...
the System DSN name is CE10 and it's SQL Server driver. the server doesn't have SQL installed on it, i believe it's just MSDE since this Train server didn't have a SQL Server engine installed on it. i just let the CE setup install MSDE way back when. and in the odbc info for the System DSN...
i did a netstat -b and found the following info on ports:
TCP SVRNAME:2410 [inputfileserver.exe]
TCP SVRNAME:2412 [outputfileserver.exe]
TCP SVRNAME:2432 [WebCompServer.exe]
TCP SVRNAME:2526 [pageserver.exe]
TCP SVRNAME:2527 [pageserver.exe]
TCP SVRNAME:3470 [CrystalMS.exe]
TCP...
forgot to mention, i'm using CE10. that's what's supposed to show in the CMS Data Source field (as it did before) but is not showing now. that is what my ODBC connection points to and it tested successful for connectvity in odbcad.32 and then again when i used the Specify option on the...
well, i'm running it under the System account as i was before. looking in the Application Event log, i'm not finding anything about what Db it's using. i see lots of starts and stops for the CMS and several messages about "port already in use". i'm sure the port already in use is when i've...
OMG Turkbear! that worked...with one exception. i cannot get the CMS to start. i tried starting it in the CCM and it just sat there. so i went into the Properties of the CMS and noticed on the Configuration tab, that there was nothing in the CMS Data Source field (compared it to a Test...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.