Re: [Blind-sysadmins] SQL Server
Hi, Thanks for this info. All of you have been very helpful so far. I'm a complete Newbee in-terms of managing SQL DB's. The most I did at University was query the Databases and Create them using the command line, but I've never worked on the Server stuff. I can't connect to .\sqlexpress. It keeps timing out. When I bring up the SQL Config Man I see in there two Databases that I'm using for an asset management project. However, I don't' want this to use these Databases. I've found a youtube tutorial on SQL which will help me get started. Any ideas why I'm getting the following error though when I'm trying to connect to .\sqlexpress? "Cannot connect to .\sqlexpress. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)" Regards, Barry. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Timothy Spaulding Sent: 05 November 2012 12:39 To: Blind sysadmins list Subject: Re: [Blind-sysadmins] SQL Server Hi, When you launch SQL Server Management Studio (SSMS), you are prompted for a server to connect to. In this box, you wound type: Servername\sqlexpress Where servername is the computer you install SQL to. (since you mentioned it was SQL Express you installed) If you are on the same server, you could have easily typed in: .\sqlexpress (that is a period backslash then sqlexpress) To set the authentication mode to mixed mode (supporting both SQL Authentication and Windows Authentication), right click on the server name and select properties. On the left side of this property sheet there is a few choices. Chose Security and tab to a radio button for Mix mode authentication. Then, ok out of the dialog box. To set the SA password, back to the object view where you saw the computer name; this is a tree view. Expand the computer name, arrow down to security and expand it, then arrow down to login and expand it; then arrow down to SA and get properties on this account. You can set the password in this dialog. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Barry Toner Sent: Monday, November 05, 2012 6:57 AM To: blind-sysadmins@lists.hodgsonfamily.org Subject: [Blind-sysadmins] SQL Server Hi folks, I've been tasked to setup a Helpdesk for our company. I'm going with nService, http://www.avensoft.com/ The DB uses SQL. Thing is I've no idea about SQL Servers. I've installed SQL Express by reading the nService RTM. OK, fine, it's installed, and according to the Management and Config it's running. The next few things I'm asked to do I'm confused about and can't find the options for this. Switch to SQL Server and Windows Authentication mode Enable the "sa" account and set a password Also I've no idea the name of the SQL Server to connect to it. Would this just be local or locahost? If it's any good I've IIS installed and running as well. Can someone please tell me how I do this so I can continue with the installation? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins
Hello, I have encountered a problem with using Jaws on servers since the release of Jaws 14. fsbrldspapi.dll is loded by Jaws during Installation if your installing it while standing in front of the server but if your installing Jaws remotely using the /type remote switch the installation doesn't speak or provide Braille output. Therefore the fsbrldspapi.dll file will be loded when you run Jaws for the first time. When you are installing or running Jaws on a system be it a server or workstation running on Windows 2008, 2008R2, 7 or 8 without Internet access you will encounter the following error message: "JFW>EXE Referral returned from the server". It would appear that this issue began popping up around April with the update of Jaws 13 around that time. The problem is that the Jaws driver signing program requires trusted certs that are downloaded from Microsoft on an as needed basis. More details about how trusted certs are downloaded in Windows 2008 and 2008R2 can be found at the following Microsoft KB link: http://support.microsoft.com/kb/931125 In previous versions of Windows up to XP and 2003 Windows updates included these certs. However, it would appear that it is all but impossible or at best very difficult to apply these certs to servers that are off line. The only way I can see of doing it at the moment is to find the required cert and install it on each system. Probably through a SCCM advertisement. I have asked FreedomScientific to get back to me on this but although I know that a lot of their staff are on vacation this week due to the thanks giving holiday I have no confidence that they will resolve this new dependency. In my opinion this is a bug that should be resolved. At the very least, a specific error message should be provided when Jaws cannot start due to this issue. What really should happen is that when certs can not be used Jaws starts as much functionality as possible without loding this DLL. In other words Braille wouldn't be available. I know that some users really need braille and I'm being a bit selfish here so I'm really sorry. I have reported a large number of bugs to FreedomScientific since the release of Jaws 14. I am hoping that they will be resolved however I get the usual answer of "No one else has reported this" and "We cant reproduce that problem here". I feel like i'm fighting an up hill battle. I know that people like John, Bryan and Eric are decent people. Their easy to talk to and I get the impression that their good at their job so I don't know what is blocking the resolution of these problems. If anyone has any suggestions then I'm all ears. Otherwise, if you could Email support@freedomscientific.com with any problem your having with Jaws 14 we might get some pressure put on the developers to prioritise a bug fixing excersize. Regards Darragh Ó Héiligh Fujitsu Offices of the Houses of the Oireachtas, Fredrick Building, South Fredrick Street, Dublin2 Telephone: +353 (1) 618 3559 Email: darragh.oheiligh@oireachtas.ie Internet: http://www.oireachtas.ie Oireachtas email policy and disclaimer. http://www.oireachtas.ie/parliament/about/oireachtasemailpolicyanddisclaimer... Beartas ríomhphoist an Oireachtais agus séanadh. http://www.oireachtas.ie/parliament/ga/eolas/beartasriomhphoistanoireachtais...
Hello, I have encountered a problem with using Jaws on servers since the release of Jaws 14. fsbrldspapi.dll is loded by Jaws during Installation if your installing it while standing in front of the server but if your installing Jaws remotely using the /type remote switch the installation doesn't speak or provide Braille output. Therefore the fsbrldspapi.dll file will be loded when you run Jaws for the first time. When you are installing or running Jaws on a system be it a server or workstation running on Windows 2008, 2008R2, 7 or 8 without Internet access you will encounter the following error message: "JFW>EXE Referral returned from the server". It would appear that this issue began popping up around April with the update of Jaws 13 around that time. The problem is that the Jaws driver signing program requires trusted certs that are downloaded from Microsoft on an as needed basis. More details about how trusted certs are downloaded in Windows 2008 and 2008R2 can be found at the following Microsoft KB link: http://support.microsoft.com/kb/931125 In previous versions of Windows up to XP and 2003 Windows updates included these certs. However, it would appear that it is all but impossible or at best very difficult to apply these certs to servers that are off line. The only way I can see of doing it at the moment is to find the required cert and install it on each system. Probably through a SCCM advertisement. I have asked FreedomScientific to get back to me on this but although I know that a lot of their staff are on vacation this week due to the thanks giving holiday I have no confidence that they will resolve this new dependency. In my opinion this is a bug that should be resolved. At the very least, a specific error message should be provided when Jaws cannot start due to this issue. What really should happen is that when certs can not be used Jaws starts as much functionality as possible without loding this DLL. In other words Braille wouldn't be available. I know that some users really need braille and I'm being a bit selfish here so I'm really sorry. I have reported a large number of bugs to FreedomScientific since the release of Jaws 14. I am hoping that they will be resolved however I get the usual answer of "No one else has reported this" and "We cant reproduce that problem here". I feel like i'm fighting an up hill battle. I know that people like John, Bryan and Eric are decent people. Their easy to talk to and I get the impression that their good at their job so I don't know what is blocking the resolution of these problems. If anyone has any suggestions then I'm all ears. Otherwise, if you could Email support@freedomscientific.com with any problem your having with Jaws 14 we might get some pressure put on the developers to prioritise a bug fixing excersize. Regards Darragh Ó Héiligh Fujitsu Offices of the Houses of the Oireachtas, Fredrick Building, South Fredrick Street, Dublin2 Telephone: +353 (1) 618 3559 Email: darragh.oheiligh@oireachtas.ie Internet: http://www.oireachtas.ie Oireachtas email policy and disclaimer. http://www.oireachtas.ie/parliament/about/oireachtasemailpolicyanddisclaimer... Beartas ríomhphoist an Oireachtais agus séanadh. http://www.oireachtas.ie/parliament/ga/eolas/beartasriomhphoistanoireachtais...
participants (2)
-
Barry Toner -
Darragh OHeiligh